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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.