Skip to main content

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.