Forum Discussion
Solved
External table is not in the expected format.
i am trying to load data in powerbi from excel which is in XLSB format somtimes able to load bt somtime getting error saying External table is not in the expected format. do anyone know what sholu...
the way power bi imports data for XLSB files is very different then XLSX. Please try to convert it into XLSX then your issues should get resolved. If that is not something possible then follow the approach suggested here: Importing XLSB into Power BI - Excelerator BI
Need a Power BI Consultation? Hire me on Upwork
Connect on LinkedIn
Did I answer your question? Mark my post as a solution! If I helped you, click on the Thumbs Up to give Kudos.
Proud to be a Super User!
the way power bi imports data for XLSB files is very different then XLSX. Please try to convert it into XLSX then your issues should get resolved. If that is not something possible then follow the approach suggested here: Importing XLSB into Power BI - Excelerator BI
Need a Power BI Consultation? Hire me on Upwork
Connect on LinkedIn
|