Forum Discussion

benmccarthy's avatar
benmccarthy
Frequent Visitor
2 years ago
Solved

Error connecting to MS Access as a data source

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

MS Access
  • lbendlin's avatar
    lbendlin
    2 years ago

    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.

  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

3 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.