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

[gdarmohray]

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:

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?

[SaritaSenapati]

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