Skip to main content

    Power BI

    Needs Votes

    Excel Binary file support

    Vote (337) Share
    Krati Singh's profile image

    Krati Singh 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 (25)
    Krati Singh's profile image Profile Picture

    Power BI User on 05 Jul 2020 22:52:59

    RE: Excel Binary file support

    Add support

    Krati Singh's profile image Profile Picture

    Power BI User on 05 Jul 2020 22:50:45

    RE: Excel Binary file support

    Please install AccessDatabaseEngine.exe of Microsoft Access 2010
    from https://www.microsoft.com/en-us/download/

    Krati Singh's profile image Profile Picture

    Dan on 05 Jul 2020 22:39:13

    RE: Excel Binary file 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.

    Krati Singh's profile image Profile Picture

    Steve on 05 Jul 2020 22:30:47

    RE: Excel Binary file support

    Can you please add support for opening XLSB files

    Krati Singh's profile image Profile Picture

    Power BI User on 05 Jul 2020 22:30:38

    RE: Excel Binary file support

    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.