Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

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

I have 3 sources, a folder with Excel files that are combined in Power Query, a separate Excel file and an Access database but they're Excel and Access files. All files have either *.xlsx or *.accdb. Both are Office 365 64bits. I created my Power Bi desktop file and works ok but when I publish it on a Sharepoint site, and I try refreshing the dataset, I get this error. 





I've tried installing both versions of the Microsoft Access Database Engine 2010 and 2016 and still get the same error. If I try to publish the Access database as a list on the Sharepoint site, it would take a lot of time since it's updated daily and as of today, it has aproximately 500k registers. All the Excel files in the folder are deleted after 7 days and are replaced with new ones. 

Super User IV
Super User IV

@LuisPedro , refer if this can help

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!


@amitchandak Thanks for the reply,

I have both 64 bits installed. After reading the link you posted, it says that If I install de 32 bits, It would work?




Helpful resources

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!


Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors