Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi,
One of my reports in Power BI service was scheduled using my personal gateway and was working fine. Recently, I changed the gateway from personal to Enterprise, but the report failed to refresh with the below error.
The following exception occurred while the managed IDbConnection interface was being used: The keyword isn't supported: version. Parameter name: keyword. A connection could not be made to the data source with the Name of 'ca000f1d-0fa0-474a-9c98-199cb11c3a86'. The database operation was cancelled because of an earlier failure. |
I have the pro version, if that helps. Can anyone let me know how to solve this?
I have the same problem for three data sets. What they have in common is that all three of them have static tables entered under that relativly new feature in P.BI desktop enter data. I've tried running the refresh on the same reports after I disabled those static tables ( edit queries/ properties/ untick enable load to report) and they work fine. I've tried putting them into seperate excel files and d=creating a connection to those excel files on the enterprise gateway but I'm having problems establishing that connection. I keep getting the error could not find a part of the path. Any ideas on what the full absolute path is ment to look like?
Are u sure to have the same error?
<<The following exception occurred while the managed IDbConnection interface was being used: The keyword isn't supported: version. Parameter name: keyword. A connection could not be made to the data source with the Name of 'ca000f1d-0fa0-474a-9c98-199cb11c3a86'. The database operation was cancelled because of an earlier failure.>>
I've tried your workaraound but i can't notice any differences.
I suppose the problem is about when powerquery has to get external data, and this is not the case of local entered data.
I've tried to reinstall enterprise gateway, to remove "entered data", to reconfigure gateway... i'm still stuck.
When i update report on PowerBi Desktop all work out fine.
I'm wondering if enterprise gateways are still in testing phase.
I've got a response from the Microsoft Tech Staff.
They has recognized a bug onto "enter data" feature and the Enterprise Gataway. Personal Gateway is not Affected.
They told me that the fixing is ongoing but there is no ETA for now.
hope that this help.
other news from Microsoft Tech stuff:
Also self entered LIST generate this error.
So if you have a datatable generated in powerquery without any external connection you will experiment this bug.
This append obviusly only if you connect a enterprise gateway to the report, if you have only cloud datasource you will not experiment this.
Same problem but on Mysql.
Getting the exact same error.
What I've done so far:
In short... The only thing I can get to work are the cubes for the administrator alone.
What am I doing wrong here ?
Getting the same thing but with an oracle data source.
Something went wrong. An error occurred while processing the data in the dataset. Processing errorThe following exception occurred while the managed IDbConnection interface was being used: The keyword isn't supported: version. Parameter name: keyword. A connection could not be made to the data source with the Name of '280c1903-f21e-476f-8b57-2238fb0afb06'. The database operation was cancelled because of an earlier failure. Cluster URIWABI-US-EAST2-redirect.analysis.windows.net Activity ID27984803-23ba-ca22-1977-de756fb70b2c Request IDe24c72aa-85a8-5d44-88a6-6b5e5b753674 Time2016-03-18 16:58:49Z
I have other datasets that work fine. The only thing I can see different in this one is that it has a table created inside PBI Desktop.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
37 | |
30 | |
18 | |
14 | |
8 |
User | Count |
---|---|
50 | |
38 | |
31 | |
15 | |
13 |