cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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. 

 

Error_PBI.png

 

 

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. 

2 REPLIES 2
Highlighted
Super User IV
Super User IV

@LuisPedro , refer if this can help

https://exceleratorbi.com.au/64-bit-power-bi-desktop-32-bit-office-can-do/



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!

Highlighted

@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?
Microsoft_Access_database_Engine2016.png

 

Access.png

 

Helpful resources

Announcements
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!

secondImage

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