Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
andkim
New Member

Power BI Desktop Not Connecting to Access

I get this error message whenever I try to connect to an Access database (PowerBI.accdb for example), but I can connect to Excel spreadsheets just fine.  

 

Details: "Microsoft Access: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. The 64-bit version of the Access Database Engine 2010 Access Database Engine OLEDB provider is required to connect to read this type of file. To download the client software, visit the following site: https://go.microsoft.com/fwlink/?LinkID=285987."

 

I don't know what this error message means.  I followed the link shown and installed the latest version of Power BI Desktop as it instructed.  I have 64-bit Office and Power BI Desktop, but I'm still getting this same error message.  Please help.

1 ACCEPTED SOLUTION
DoubleJ
Solution Supplier
Solution Supplier

Hi

 

I guess you need to download the Microsoft Access Database Engine driver. You can download it here: https://www.microsoft.com/en-us/download/details.aspx?id=13255

 

Hope this helps

JJ 

 

View solution in original post

2 REPLIES 2
DoubleJ
Solution Supplier
Solution Supplier

Hi

 

I guess you need to download the Microsoft Access Database Engine driver. You can download it here: https://www.microsoft.com/en-us/download/details.aspx?id=13255

 

Hope this helps

JJ 

 

That totally did the trick for me.  

Thank you so much JJ!

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.