Reply
Frequent Visitor
Posts: 3
Registered: ‎06-09-2016

Unable to connect : Access file through Power BI

[ Edited ]

Hi All,

 

I am getting the following error. How to fix this? any help is highly appreciated!

 

I am using Windows 10, access 2016.

 

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."\

 

Also, what is the purpose of the Acess database engine?

 

Thanks..

Frequent Visitor
Posts: 3
Registered: ‎06-09-2016

Re: Unable to connect : Access file through Power BI

I think you have to install access of 64-bit.

Frequent Visitor
Posts: 2
Registered: ‎06-07-2016

Re: Unable to connect : Access file through Power BI

Hi Chitra, 

 

Please check the version of MS Access installed on your computer. Also check the version of PowerBI installed. 

You should have the same version of PowerBI as your MS Office install.

 

The purpose of the database engine is to allow PowerBI to connect to MS access.

Frequent Visitor
Posts: 2
Registered: ‎06-11-2016

Re: Unable to connect : Access file through Power BI

Hi, I have the exact same problem.

 

I run a Windows 10, with Access 2016 [v16.0.6925.1016 - 32-bit] and Power BI Desktop [v2.35.4399.601 - 32-bit May]

 

I have un/re-installed everything, but I still get the error message.

 

Please advice.

 

Kindly,

Joachim

Frequent Visitor
Posts: 3
Registered: ‎06-09-2016

Re: Unable to connect : Access file through Power BI

Hi Cronquist,

 

I sorted out my issue.

 

things to check :

 

- MS office 2016 32-bit

- Power BI 32 - bit

 

once you have the same 32-bit version, download and install "AccessDatabaseEngine" from the below link.

 

https://www.microsoft.com/en-us/download/details.aspx?id=13255

 

It works fine.

 

Let me know if you still have issues.

Frequent Visitor
Posts: 2
Registered: ‎06-11-2016

Re: Unable to connect : Access file through Power BI

@Chitra thanks alot, that solved my problem.

Frequent Visitor
Posts: 2
Registered: ‎01-04-2017

Re: Unable to connect : Access file through Power BI

thank you

Frequent Visitor
Posts: 5
Registered: ‎02-06-2017

Re: Unable to connect : Access file through Power BI

Hi Chitra

 I am getting the same error , please how to fix it?, thanks

Member
Posts: 138
Registered: ‎03-10-2016

Re: Unable to connect : Access file through Power BI

Download and install "AccessDatabaseEngine" from the below link.

 

www.microsoft.com/en-us/download/details.aspx?id=13255 

Regular Visitor
Posts: 27
Registered: ‎02-08-2017

Re: Unable to connect : Access file through Power BI

I ran into the same issue

Office 2010 32bit

PowerBI 64 bit

 

Theni installed the Access DB from the above line and i was able to connect to the file. 

Thanks to this forum ran into issue 5 min back and I good to go now Smiley Happy

 

 

Thanks