topic Error connecting to MS Access as a data source in Report Server

Error connecting to MS Access as a data source

benmccarthy — Mon, 03 Jun 2024 10:46:59 GMT

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

Re: Error connecting to MS Access as a data source

lbendlin — Mon, 03 Jun 2024 23:39:21 GMT

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.

Re: Error connecting to MS Access as a data source

Anonymous — Thu, 06 Jun 2024 02:32:44 GMT

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.

Re: Error connecting to MS Access as a data source

mohdmohideen200 — Sun, 09 Mar 2025 04:39:45 GMT

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