Hi, I am trying to load a table from excel sheet which has headers. When I load it in Power BI, header row is missing and it just displays Column 1, 2 ,3 etc and then the data. Am I missing something? Thanks.

I got it. I had to remove all the filters first and then load the table and then apply the solution you suggested. Thanks for your help on this !

Header row not showing up | Microsoft Fabric Community

Shiva_kumar
New Member
3 years ago
Go to get data
Click on the data source you need
As example I'm taking Sharepoint online list..
Here is detail
Now we find implementation 1.0 and 2.0
Click on 2.0
You find options Like this below screenshot
By default it takes All
But click on Default
You will now get the headers
Isha
Manuel
Frequent Visitor
10 years ago
hello you have to charge the tablet directly from the query editor there you will find the option to add the first row as header.
regards
Vvelarde
Community Champion
10 years ago
hi Isha

Go to Edit Query and select First row as header

Select first row as header
- Isha
  Frequent Visitor
  10 years ago
  The issue is that header row is not even showing up when table is loaded. The data underneath is only pulled up and displayed. So even if I try to make first row as header, it will be a data row and not actual header columns.
  - Isha
    Frequent Visitor
    10 years ago
    I got it. I had to remove all the filters first and then load the table and then apply the solution you suggested. Thanks for your help on this !