Forum Discussion

Shivkanyabyale's avatar
Shivkanyabyale
Frequent Visitor
2 years ago
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...
Need Help
  • tharunkumarRTK's avatar
    tharunkumarRTK
    2 years ago

    Shivkanyabyale 

     

    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!
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Agree with tharunkumarRTK .

Excel binary file .xlsb is not a support data source in Power BI. Ideas had already been submitted. Please Vote it on the link below.

Microsoft Idea

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.