Power BI: define a row as header/title for a table

Sometimes when I load an excel sheet, Power BI doesn’t recognize the header and it defines a new title by itself, something like that:

Excel Power BI
power bi power bi

In this case, instead to try to figure out what’s wrong, in Power BI, there is way to put it correctly.

  • 1. Home -> transform data -> transform data
power bi
  • 2. Home -> use first row as headers
power bi
  • 3. Close & Apply
power bi

Interesting Management