Excel text row being imported as null values, but there are there in Excel

[Cogidubnus_Rex]

So, very strange one.

I'm refreshing data for a pbix file (i.e. connecting to a new data set in the same format as the previous source file), and suddenly I'm getting errors in QE as the top row of text (before it gets promoted as headers) is coming up with null values, instead of the text in the original Excel.

I've downloaded the latest PBI version, used multiple computers, but it's not working, and we're only talking about 80k rows being imported.

When I delete all rows in the Excel file but the top few and then import, suddenly the top row of text is being recognised correctly.

I've never seen this before, and I am in need of help, pretty please with a cherry on top.

[Anonymous]

Good afternoon to all.

This is my first time giving a reply to someone, so please forgive me if is something lacking.

I had the exactly same problem and the solution was extrange, I had to eliminate the format of the title column of the Excel table.

After that the Power Bi can take the values of the first row and make it column header.

Note: the format came from the standard report of SAP.

I hope this help.

Best regards.

Javier

[v-kelly-msft]

Hi @Cogidubnus_Rex ，

Does all the columns show null values?Or does this situation only happen in certain positions?Such as a certain column with a certain line?If so ,pls check and make sure that all the data in the column have the same type.

Best Regards,

Kelly