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

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