Access DB Dataset Refresh error Microsoft.ACE.OLEDB.12.0

[BenderIsGreat]

I have a report built in PBI Desktop using an Access DB on Sharepoint as a source (using the Sharepoint folder Connector).  I can work with the file in desktop no problem and refresh at will.  When I publish the report to service, I get an error regarding the Access OLEDB provider.

I have the Access Database Engine installed on my local machine and, as mentioned, I can refresh in desktop no problem.  I can also pull a local copy of the Access DB and open/edit it.  This only seems to be impacting when published to service.  This worked fine for the first few days after it was published and only staretd erring at the end of August.  I see many mentions of this error in relation to having a .xls Excel source, but nothing around AccessDB as a source.   I've gone through this article as well to no avail.

Has anyone else seen this and were you able to fix it?  For now, whenever teh data is refreshed I have to open in Desktop, refresh, publish.  Would much prefer to let the data set refresh daily within service

Thanks!

[Anonymous]

I met the same problem.  I thought PowerBI cloud server should install the Access 2010 - 64bit.  

[v-piga-msft]

Hi @BenderIsGreat,

By my tests with using an Access DB on Sharepoint as a source(using the Sharepoint folder Connector) as your option. I could reproduce your issue like below.

Actually, if we want to connect the access DB in SharePoint, please follow the steps which could refresh successfully in Power BI Service by my test.

1. Create your table in Access and save it as SharePoint then you will get the table list in your site in SharePoint.

2. Then we should connect this data source in SharePoint with the SharePoint Online list connector.

3. Create the report and publish it to Power BI Service. Go to Setting and find the dataset of the report then edit credential.

4. Then when you change your data source in Access and refresh in Power BI Service, it will work as expected.

Best Regards,

Cherry