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

[DanieleS]

Hello!
When I update my PBI file on browser it returns me this error:

• Codice errore sottostante-2147467259
• Messaggio di errore sottostanteMicrosoft Access: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. The 64-bit version of the Access Database Engine OLEDB provider may be required to read 'Azienda.Mdb'. To download the client software, visit the following site:
• DM_ErrorDetailNameCode_UnderlyingHResult-2147467259
• Microsoft.Data.Mashup.ValueError.ReasonDataSource.NotFound
• URI clusterWABI-WEST-EUROPE-E-PRIMARY-redirect.analysis.windows.net
• ID attivitàf0996aca-4148-41f6-87d0-0ad19591125e
• ID richiesta7ed0bdce-816a-1171-5b15-1da65c837443

Ora2022-09-15 10:57:58Z

So, i have installed on my server wiht Windows Server 2019, Office 2013 32bit, Power Bi Desktop 32bit and Personal Gateway.
PBI file has two soruces: a excel file and an access file (.Mdb) 

Readgin online, i installed Microsoft Access Database Engine 2010 Redistributable but erros doesnt fix.

How can i do?

Thank you

[v-xiaoyan-msft]

Hi @DanieleS ,

Double check that you have properly installed the corresponding ODBC drivers:

• Microsoft Data Access Components (MDAC) 2.8 SP1

• Microsoft Access Database Engine 2010 Redistributable

If everything is set up correctly, check your Microsoft Office architecture (64 or 32 bit).

In case you are attempting to use ODBC on a 64-bit machine whilst your Microsoft Office version is 32-bit:

• Download this installer here.

• Do export the contents of the zip file to your desktop.

• Exit WinAutomation from the system tray by right clicking on the WinAutomation action and selecting "Exit".

• Right click on the executable file called "ForceDotnet32bitOnExeFiles.exe" and select "Run as Administrator"

This will handle all the configuration changes needed to be done so that you can combine a mix of 32- and 64-bit Office and Windows.

ACE.OLEDB.12.0 provider not registered on local machine | Microsoft Docs

Best Regards,
Community Support Team _ Caitlyn

[DanieleS]

Hello and thanks for your answer!


None of solutions work 😞