Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
benmccarthy
New Member

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

2 ACCEPTED SOLUTIONS
lbendlin
Super User
Super User

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.

View solution in original post

v-xiandat-msft
Community Support
Community Support

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.

View solution in original post

2 REPLIES 2
v-xiandat-msft
Community Support
Community Support

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
Super User
Super User

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.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.