Reply
New Member
Posts: 1
Registered: ‎02-13-2017

Lab 1: Access Database Upload Problem

Hello,

 

I keep getting the same error everytime I try opening the Access database on Power BI. I'd really appreciate if someone could please help me out.

Below is the exat error:

 

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

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

Re: Lab 1: Access Database Upload Problem

You need to install Access Database Engine by the link above.

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

Re: Lab 1: Access Database Upload Problem

I had the same problem, and it was caused because I had the MS Office x32 bits installed, and the PowerBI desktop in x64. All you have to do is to install the PowerBi version (x32 or x64) according to your Office.

Highlighted
Frequent Visitor
Posts: 5
Registered: ‎02-16-2017

Re: Lab 1: Access Database Upload Problem

I had the same problem. I had installed MSOffice for 32 bits and Power Bi Desktop x64 version. All you have to do is either install the PowerBI x32 or install MSOffice x64.

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

Re: Lab 1: Access Database Upload Problem

Please install Access Database Engine