cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

64-bit Desktop BI cannot Get Data from 64-bitAccess 2016. Click-to-Run error

I tried to Get Data from 64-bit Power BI from 32-bit Access.  I get the expected error message:

 

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

 

 

I uninstall 32-bit Office, reboot and install 64-bit Office Professional Plus 2016.  Access now shows "Microsoft Access 2016 MSO (16.0.7571.7095) 64-bit"

 

I try again to Get Data on Access and still get the above error.    I download 64-bit version of "Microsoft Access Database Engine 2010 Redistributable" availabe from here: https://www.microsoft.com/en-us/download/details.aspx?id=13255.

 

I now get the following error:


Microsoft Error.jpg

 

Any advice on how to get my 64-bit Windows 10 Professional environment to support 64-bit Power BI to Get Data from 64-bit Access?

1 REPLY 1
Helper I
Helper I

Re: 64-bit Desktop BI cannot Get Data from 64-bitAccess 2016. Click-to-Run error

Hi @gdarmohray,

 

I had the same issue. I think you will need to update your microsoft office as well.complete detail can be found here https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-access-database-errors/

 

Now there is another way of getting access data in power BI  by following the below steps:-

 

1) open excel -> click on Data tab-> click on from Access-> import the desired file.

2) if your desired file has multiple sheets in it, go to step 3  otherwise go to step 4.

3)In select Table window, select " enable selection of multiple tables" and then select desired tables.

4) In import table window, select "table" and then click on ok.

5) save the excel sheet created using above steps.

6) open power bi -> click get data-> import the saved excel sheet.

 

Regards,

Sarita

 

 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors