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
Amyinformatics
New Member

Lab 1 challenge

Please i need assistance as i am not able to progress beyond this level. When i try to import the access file fro access DB into Power BI desktop i get the below response.  How do i solve this issue

 

Unable to connect

We encountered error while trying to connect

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 may be required to read 'Database1.accdb'. To download the client software, visit the following site: https://go.microsoft.com/fwlink/?LinkID=285987."

1 ACCEPTED SOLUTION
v-yuta-msft
Community Support
Community Support

@Amyinformatics ,

 

The issue should be caused by no access engine has been installed or the bit version of power bi desktop is different from bit version of access engine.

 

Please refer to:

https://docs.microsoft.com/en-us/power-bi/desktop-access-database-errors

 

Community Support Team _ Jimmy Tao

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

View solution in original post

3 REPLIES 3
v-yuta-msft
Community Support
Community Support

@Amyinformatics ,

 

Have you solved your issue by now? If you have, could you please help mark the correct answer to finish the thread? Your contribution will be much appreciated.

 

Regards,

Jimmy Tao

 

 

v-yuta-msft
Community Support
Community Support

@Amyinformatics ,

 

The issue should be caused by no access engine has been installed or the bit version of power bi desktop is different from bit version of access engine.

 

Please refer to:

https://docs.microsoft.com/en-us/power-bi/desktop-access-database-errors

 

Community Support Team _ Jimmy Tao

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

VijayP
Super User
Super User

Please look at the link which Microsoft Provided.

The link is there in your question! Follow that




Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
MY Blog || My YouTube Channel || Connect with me on Linkedin || My Latest Data Story - Ageing Analysis

Proud to be a Super User!


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.