Skip to main content
Microsoft Idea

    Power BI

    Needs Votes

    install Microsoft.ACE.OLEDB.12.0 on Power BI Service refresh infrastructure

    Vote (2) Share
    Greg Galloway's profile image

    Greg Galloway on 09 Nov 2019 01:58:33

    When you have an Access Database (.accdb) file in SharePoint Online and you load from a "SharePoint Folder" data source then load that file, it loads fine from Power BI Desktop but when published to the services you can't refresh without an On-Premises Data Gateway which has Microsoft.ACE.OLEDB.12.0 installed. Please install Microsoft.ACE.OLEDB.12.0 on the built-in Power BI Services data refresh infrastructure in the service so we can do such a refresh without an On-Premises Data Gateway.