Loading Access databases

[joehav]

I have 64 bit Office 365 and 64 bit Power BI but still get an error trying to load.  Says I need the Office 10 driver for Access.

[v-yuezhe-msft]

Hi @joehav,

Could you please post the full error message? Additionally, please ensure that you have installed 64 bit version of Access Database Engine on your machine.

Reference:
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-access-database-errors/

Thanks,
Lydia Zhang

[joehav]

As I mentioned, I'm using Office 365 (Access 2016) and I installed the 64 bit version.  This is the error message

[v-yuezhe-msft]

Hi @joehav,

The above error could occur when you install incorrect bit-ness of client. Please double check the bit version of your Office, Power BI Desktop and Microsoft Access Database Engine 2010 Redistributable . Make sure that Access Database Engine version matches your Power BI Desktop version.

Thanks,
Lydia Zhang

[joehav]

This is my Access version

This is my Power BI version

[v-yuezhe-msft]

Hi @joehav,

Could you please check that if you have the following registry entry in you machine.

HKLM\Software\Microsoft\Office\16.0\Access Connectivity Engine\InstallRoot\Path

Thanks,
Lydia Zhang

[joehav]

No I don't.

[v-yuezhe-msft]

Hi @joehav,

Which package do you use to install Access database engine?

Thanks,
Lydia Zhang

[joehav]

Package??  I logged on to my account at the Office 365 website and requested a download.

[v-yuezhe-msft]

Hi @joehav,

Do you download 64 bit Access database engine 2010 Redistributable  from the following link and install it on  your machine?

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

Thanks,
Lydia Zhang