Forum Discussion

JJesus_powerbi's avatar
JJesus_powerbi
Frequent Visitor
6 years ago

Error importing .xls file with blank rows

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 happen...
v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
6 years ago

HI  JJesus_powerbi 

You may try to 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.

 

Regards,

Lin