Skip to main content

    Power BI

    New

    web xls

    Vote (98) 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 (9)
    Mike Honey's profile image Profile Picture

    483bc89e 7fd2-ea11-a812-000d3a563be2 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

    211145df e1e4-41cf-b06d-8b602760ad8f 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

    ee12ec63 0bee-4b61-a358-1f928dd3843b 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

    f1383c20 a7f5-41a2-a2c8-f6df9c459f12 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

    a04b49e3 5729-4dfc-8cab-38fa9f17701e 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

    4e2ed990 e62a-4956-94cf-e2ae7078a9e9 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

    6aae92ef d3fa-4c74-abdd-79382e85fd62 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

    4e2ed990 e62a-4956-94cf-e2ae7078a9e9 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

    af0019aa 9a7e-4776-9021-7b1171cd13bc 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