The 'Microsoft.ACE.OLEDB.12.0' provider is not registered

[mwassie]

Hello,

Could you please help me with the bellow error?

The repot was automatically refreshed each week. Nothing changed. The sources are the same with the same format (xlsx and csv)

DataSource.NotFound: <ccon>Excel Workbook: 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 this type of file. To download the client software, visit the following site: https://go.microsoft.com/fwlink/?LinkID=285987.. </ccon>. The exception was raised by the IDbCommand interface. Table: Calendar.

[Jeanxyz]

I encounter the same error message in PB Desktop, but my source file is in xlsx format. After some checking, I realize in Power Query, there are some helper queries which is pointing at a personal sharepoint folder that I don't have access to. After deleting those queries, my report is back to work.

[Syndicate_Admin]

If someone has that problem connecting access to VB. just change the "target CPU" to x64 or some other until it works. This is at the top of "Project", then in Properties and finally in "Compile"

[v-yangliu-msft]

Hi  @mwassie ,

This is the related document, you can view this content:

Power BI online refresh - 'Microsoft.ACE.OLEDB.12.... - Page 2 - Microsoft Power BI Community

Solved: "Microsoft Access: The 'Microsoft.ACE.OLEDB.12.0' ... - Microsoft Power BI Community

Solved: Microsoft Access: The 'Microsoft.ACE.OLEDB.12.0' p... - Microsoft Power BI Community

The 'Microsoft.ACE.OLEDB.12.0' provider is not reg... - Microsoft Power BI Community

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

Best Regards,

Liu Yang

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

[amitchandak]

@mwassie , Try to install this

https://www.microsoft.com/en-us/download/details.aspx?id=54920

or refer

https://docs.microsoft.com/en-us/answers/questions/474336/how-to-fix-microsoftaceoledb120-provider-i...

https://community.powerbi.com/t5/Desktop/Microsoft-Access-The-Microsoft-ACE-OLEDB-12-0-provider-is-n...