Error importing .xls file with blank rows

Question

Good afternoon

I have an .xls file that powerbi doesn't matter correctly. The .xls file is generated by an excel 97-2003.

If imported as an excel workbook, there are blank fields (this happens because the file has the first 2 blank rows). If you open the file by activating compatibility mode with a newer version and save the file, if you read the fields.

If the file is imported as a csv file there is no language that reads the file correctly.

How can you successfully import excel from 97-03?

Best regards.

amitchandak · Answer

JJesus_powerbi , check, is there any known issue or log a new one: https://community.powerbi.com/t5/Issues/idb-p/Issues

v-lili6-msft · Answer

HI&nbsp;&nbsp;JJesus_powerbi&nbsp;
You may try to&nbsp;make sure your original data is in Excel Tables (Press CTRL+T on your data) and then Power Query knows where the data starts and ends.
&nbsp;
Regards,
Lin