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.
26 Comments
- Can you please add support for opening XLSB files
- I have tried opening the Excel Binary file however keep getting the error "External file format not supported", is it possible for you all to add the necessary support.
- This would be a good addition. We have several large excel files that run so much better in xlsb than xlsm, so full support for xlsb would be great.
- Please install AccessDatabaseEngine.exe of Microsoft Access 2010 from https://www.microsoft.com/en-us/download/
- Add support
- I am getting an error using the xlsb excel file DataFormat.Error: External table is not in the expected format
- 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).
- 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.
- 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?
- Precisamos de suporte para XLSB
