Error connecting to MS Access as a data source

Sounds like you are trying to connect to a legacy Access db format. At a minimum you'll want to convert that to an ACCDB format, but ideally you will want to put your data into a real database (like SQL Server) that supports 64 bit natively.

Hi benmccarthy ,

Thank you for lbendlin answer , and I have other suggestions for you:

If you see an error indicating that the Access Database Engine isn’t installed, you’ll need to download and install it. Make sure to choose the version (32-bit or 64-bit) that matches your Power BI Desktop version.

You can download the Access Database Engine from the Troubleshoot Access and XLS import issues in Power BI Desktop - Power BI | Microsoft Learn

And the bit version of the Asses database engine is to be 'skinned' with the Ballbidsktop version

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.