Forum Discussion
JJesus_powerbi
6 years agoFrequent Visitor
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...
Syndicate_Admin
Administrator
4 years agoHello, I found that solution, always here on the blog.
You must downloadMicrosoft Access Database Engine 2010 Redistributable from the following link
https://www.microsoft.com/en-us/download/details.aspx?id=13255.
it may be of your use, greetings
https://community.powerbi.com/t5/Desktop/Import-excel-97-2003-sheet/m-p/600953#M285913