Unrecognized database format filename.accdb

[Anonymous]

I have used this PBIX file for over 6 months no problems.  Now suddenly - i get the above error - did something change in Power BI?  I even updated to the latest (April Update) PBI.  And i have copied this database to my local drive to verify it was not an exclusive access issue. 

Any help will be greatly appreciated!

Thanks

[V-lianl-msft]

See if this post can help you solve the issue:

https://community.powerbi.com/t5/Desktop/Error-refreshing-Access-database-data-tables-on-a-network-i... 

[negi007 · Accepted solution]

@Anonymous it may be related to powerbi upgraded version. some time, new version has upgraded connector which causes such issues.

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). For more information, go to Import Access database to Power BI Desktop.

have you tried below link

https://docs.microsoft.com/en-us/power-query/connectors/accessdatabase

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-access-database-errors#:~:text=If%20the%20Power%20BI%20Desktop,Engine%20from%20the%20downloads%20page.

Alternatively, you may try creating ODBC DSN connection string