Header row not showing up

[Isha]

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.

[Shiva_kumar]

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 

[Vvelarde]

hi @Isha

Go to Edit Query and select First row as header

Select first row as header

[Isha]

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 · Accepted solution]

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 !

[Manuel]

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