Power BI

Needs Votes

Excel Binary file support

Vote (253)

Krati on 08 Feb 2016 02:25:42

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.

Comments (22)

Comments (22)

0d79fedf 6454-43fc-8be2-43b398b45f95 on 05 Jul 2020 23:17:47

RE: Excel Binary file support

Power BI can support all sorts of files...but not excel files???!
I need to use xlsb files because they are so large, but I am have to keep making copies, saving them as xlsm and then use that in PBI.

9278cb9f c17b-4eb5-8998-a1865e5df2b2 on 05 Jul 2020 23:11:10

RE: Excel Binary file support

This really is a big restriction. Many larger Excel sheets are kept in XLSB - exactly the type of files relevant to Power BI.

7e911c68 9236-4e06-bee5-77af42d02305 on 05 Jul 2020 23:11:09

RE: Excel Binary file support

Precisamos de suporte para XLSB

d64829bb ac26-4ef0-8758-0c7f2425c393 on 05 Jul 2020 23:10:41

RE: Excel Binary file support

While I can get them to work on desktop I cannot use scheduled refresh due to the server not supporting the file format. Why is microsoft not supporting their own file formats?

9fe61ce4 0827-48b0-9f76-987b83eb77d1 on 05 Jul 2020 23:09:14

RE: Excel Binary file support

Please add support for binary files! It is preferred to use xlsb when working with large data and it would be extremely helpful and beneficial if Power BI could support it.

85411521 f4bb-4aef-a541-6e00a3c55654 on 05 Jul 2020 22:58:17

RE: Excel Binary file support

Yo pude solucionarlo instalando AccessDatabaseEngine_X64.exe descargado desde este link: https://www.microsoft.com/es-co/download/details.aspx?id=13255. Tengo Windows 8.1 de 64bits y Power BI Desktop Version: 2.49.4831.521 64-bit (agosto de 2017).
I could solve it installing AccessDatabaseEngine_X64.exe downloades from: https://www.microsoft.com/es-co/download/details.aspx?id=13255. I have Windows 8.1 64bits and Power BI Desktop Version: 2.49.4831.521 64-bit (august 2017).