Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
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 sholud be reason behind
Solved! Go to Solution.
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
|
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.
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.
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
|
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.