Excel .xlsb and .xlsx

[Anonymous]

I noticed that the .xlsb dont apply as a source in PBI, my question is, do you have any tip to change the extension to .xlsx

Because I've read about put a macro on it, but I dont want to open the file because is to large and my pc takes a lot of time, I am not sure if there are any way to do it without open it.

Regards

[v-yanjiang-msft]

Hi @Anonymous ,

According to your requirements, I search an online app can convert XLSB to XLSX, it works fine by my test, but I'm not sure if it will take a long time if your files are too large.

https://products.groupdocs.app/conversion/xlsb-to-xlsx

Best Regards,
Community Support Team _ kalyj

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

[Anonymous]

This is great! Instead of providing us built in conversion for your OWN proprietary files,  Microsoft Support tells us to upload our Confidential Company files to an unknown third party websites!
Just great!

[Syndicate_Admin]

Thank you, maybe it works for smaller files, but not for the ones I need

[AlexisOlson]

I don't think there's a great workaround at the moment.

Vote for the idea here:
https://ideas.powerbi.com/ideas/idea/?ideaid=aa27038f-5960-48be-bc9e-8651134b84d5

Prior threads:
https://community.powerbi.com/t5/Desktop/Importing-a-XLSB-file-from-Teams/m-p/2037315

https://community.powerbi.com/t5/Desktop/is-Xlsb-file-stilll-doesn-t-support-in-power-BI/m-p/580751

https://community.powerbi.com/t5/Desktop/XLSB-files-with-low-performance/m-p/1425148