Forum Discussion
Helper IOn-Premise Data Gateway and Access Databases
Hi, mgaynor
If you're connecting to an Access database from Power Query Online, the system that contains the on-premises data gateway must have the 64-bit version of the Access Database Engine 2010 OLEDB provider installed.
If you're loading an Access database to Power BI Desktop, the versions of the Access Database Engine 2010 OLEDB provider and Power BI Desktop on that machine must match (that is, either 32-bit or 64-bit).
This is the relevant document, hope to help you:
https://docs.microsoft.com/power-bi/connect-data/desktop-access-database-errors
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community SupportHi, mgaynor
If you're connecting to an Access database from Power Query Online, the system that contains the on-premises data gateway must have the 64-bit version of the Access Database Engine 2010 OLEDB provider installed.
If you're loading an Access database to Power BI Desktop, the versions of the Access Database Engine 2010 OLEDB provider and Power BI Desktop on that machine must match (that is, either 32-bit or 64-bit).
This is the relevant document, hope to help you:
https://docs.microsoft.com/power-bi/connect-data/desktop-access-database-errors
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.