Microsoft Access: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine

[AliPoTD]

Please can anyone help me with the error I'm having?

I have created a Power BI Desktop report which links to an Access database held on the company server, as well as a SharePoint folder.

All works fine in Desktop, and I have Published to the Power BI Service.

I have an existing On-premises gateway set up which is showing as online:

The problem I have is when I try to do either a manual Refresh or Scheduled Refresh from within the online Power BI Service.

I get the following message:

I have installed the accessdatabaseengine_X64.exe from https://go.microsoft.com/fwlink/?LinkID=285987   

on my laptop (not the company server) but this didn't resolve the issue. My IT support are saying this is something that needs to be on my laptop from where I use Power BI Desktop.

I have not been able to install the EULA Access Database Engine 2016 Redistributable.txt as the link in the Microsoft website doesn't work.

Can anyone help me with this issue? I'm very new to Gateways and am finding this baffling!

Many thanks in advance.

[v-heq-msft]

Hi @AliPoTD ,
According to your description and the error screenshot provided, the error message mentions that the "Microsoft.ACE.OLEDB.12.0" provider is not registered on the local machine. This is the driver used to connect to the Microsoft Access database. If Power BI is unable to find this driver, it will not be able to successfully connect to the Access database.
The error message suggests that the 64-bit version of the Access Database Engine OLEDB provider may need to be installed in order to read specific Access database files.
If you want to install Access Database Engine , you must make sure that the Access Database Engine installed is the same bit size as your computer.
As for the EULA, usually during the installation process you will encounter a step that asks you to accept or reject the end user license agreement.
You can view this document to install Microsoft Access Database Engine
Download Microsoft Access Database Engine 2016 Redistributable from Official Microsoft Download Cent...

Best regards,

Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[AliPoTD]

Thanks. I've fed this back to the IT Team who are installing the driver and rebooting the server this weekend.