Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Excel Binary file support

Excel binary file .xlsb as a data source works well for few query steps but starts crashing soon with error as "External file format not supported". Please enable excel binary file format support or provide an error in the beginning so that query steps are not performed at all.
Status: Needs Votes
Comments
Iris_Fung
New Member
Big data is getting more and more important but the file size is getting larger and larger. This could help save the power bi file size if we can import data with xlsb excel file to power bi!!
Warren_Kerr
New Member
I can load xlsb into Power BI desktop without issue, but having the source refreshed via schedule on the gateway breaks because the company server (??) likely doesn't have the old MS DB Access Engine installed. I don't want to rename the file to xlsx because it will block embedded macros.
Graeme_Lindley
New Member
Please look to implement this, we use binary excel files as they are actually quicker to download from SharePoint Online, and Power BI happily picks up input data sources from this location without any problems - it would be helpful for PBI to be able to handle excel binary worksheets.
fabio_giacomini
New Member

Boa tarde,


Favor disponibilizar a opção o mais breve possivél.



Contamos com o apoio da Microsoft.

Roderick_Dotson
New Member

In large organizations, binary files are being used to house the larger datasets. I use Power BI daily to provide reports and dashboards. Power BI is a powerful tool, and it needs to be able to access these types of files. Voting for you to add that functionality.

fbcideas_migusr
New Member
Status changed to: Needs Votes