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.

[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...