Error connecting to MS Access as a data source

[benmccarthy]

Hi,

I get the following error message when trying to refresh data that connects to an Access db.  The data source has been setup correctly and when I test the connection it works.  We are fairly new to Power Bi as a business and was hoping someone has come across the following issue.  To me it looks like the correct drivers haven't been installed on the server and if that is the case I was hoping someone would tell me what needs to be installed so I can get out IT guys to do this.

Error Msg:

SessionID: 8c647516-7dbc-48bb-8d1c-f556c4c79c5b

[0] -1055784932: DataFormat.Error: Unspecified error. QCBD DATA.MDB. . The exception was raised by the IDbCommand interface.

[1] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.

[2] -1055129594: The current operation was cancelled because another operation in the transaction failed.

[3] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.

[4] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.

[5] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.

[6] -1055784933: External component has thrown an exception.. The exception was raised by the IDbConnection interface.

Regards,

Ben

[lbendlin · Accepted solution]

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.

[mohdmohideen200]

"QCBD DATA.MDB." Shows the specific file that is causing the problem.

[Anonymous · Accepted solution]

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.

[lbendlin · Accepted solution]

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.