Skip to main content

    Power BI

    Needs Votes

    web xls

    Vote (108) Share
    Mike Honey's profile image

    Mike Honey on 05 Jul 2016 07:21:26

    Remove the limitation: "Power BI (web service) only supports importing or connecting to workbooks created in Excel 2007 and later. Workbooks must be saved as .xlsx or .xlsm file type."

    Thousands (millions?) of .xls files are published to web sites in various "open data" efforts. These can be read by Power BI Desktop, but not by the Power BI web service, making it awkward to refresh.

    Comments (10)
    Mike Honey's profile image Profile Picture

    Nils Stapf on 31 May 2022 17:16:30

    RE: web xls

    Please Microsoft, let us use your old Excel file format!! This makes scheduled refreshes impossible from our database exports...

    Mike Honey's profile image Profile Picture

    Bobby Lansing on 08 Sep 2020 17:05:37

    RE: web xls

    I believe I fixed this problem! Use the data gateway to refresh this source.



    1. Install a data gateway

    2. Add the XLS data source to the data gateway

    3. Check the box to Allow user's cloud data sources to refresh through this gateway cluster. These cloud data sources do not need to be configured under this gateway cluster.

    4. Set the data source to refresh through the gateway

    5. Refresh your dataset

    Mike Honey's profile image Profile Picture

    Favio on 06 Jul 2020 00:13:19

    RE: web xls

    There are lots of companies out there that still gets lots of data in legacy Excel XLS format. It does not make sense that Power BI Service does not support this format.

    Mike Honey's profile image Profile Picture

    David Taylor on 06 Jul 2020 00:00:11

    RE: web xls

    I couldn't connect to an xlsb file with PBI Desktop due to this error. Seems strange that there are dozens of file type PBI can connect to but not an xlsb.

    Mike Honey's profile image Profile Picture

    Matt Power BI User on 05 Jul 2020 23:46:30

    RE: web xls

    Please also include support for xlsb files as well. Many people use these because they support both macros and are substantially smaller than a comparable xlsm or xlsx file.

    Mike Honey's profile image Profile Picture

    Ricky on 05 Jul 2020 23:32:52

    RE: web xls

    it's 2018 Oct, and this idea is yet to be deliver..

    Mike Honey's profile image Profile Picture

    David Cresp on 05 Jul 2020 23:22:06

    RE: web xls

    This one is now two years old and should be an easy fix. Please MS have a look at this.

    Mike Honey's profile image Profile Picture

    Lukas Albrecht on 05 Jul 2020 23:13:02

    RE: web xls

    Same here, lots of legacy xls files are being used and not having the ability to autorefresh makes PBI obsolete.

    Mike Honey's profile image Profile Picture

    David Cresp on 05 Jul 2020 22:31:47

    RE: web xls

    This one is vital for us as we deal with a lot of xls files on the ABS web site.

    Mike Honey's profile image Profile Picture

    Mike Honey on 05 Jul 2020 22:25:06

    RE: web xls

    There's more discussion of this issue here, including examples of public websites with .xls files:

    http://community.powerbi.com/t5/Service/Dataset-Refresh-error-Microsoft-ACE-OLEDB-12-0-provider-is-not/m-p/47489