ms access

2 Topics

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
Solved
benmccarthy
1 year ago Place Report Server
1.9KViews
0likes
3Comments
Export MS Access Reports to Power BI
Hi, Got a number of MS Access applications that are "linked tabled" to a single MS SQL database. I want to amalgamate them all into a single application (Power Apps, .net desktop app, asp.net web?) but first looking to strip out all the functionality and logic out of the appliactions, so they are basically as much of just front end as possible. This includes all the reports built into them. Is there a way of export the reports and their design, to Power BI, so I don't have to re-write them from scratch, which is not my thing and is going take ages and be a world of pain. Regards, Keith.
Anonymous
3 years ago Place Report Server
929Views
0likes
1Comment