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
Highlighted
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
Ignite

Microsoft Ignite

This will be a conference that you do not want to miss!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Don't miss the Power BI Dev Camp this week!

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors