Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I am trying to load CRM data from Dynamics 365 into PowerBI. I can connect to Dynamics 365, select the data sources but after the loading sequence am given an error:
"Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: Exception of type 'Microsoft.Mashup.Engine.Interface.ResourceAccessForbiddenException' was thrown.. The following system error occurred: The following system error occurred: The following system error occurred: The following system error occurred: The following system error occurred: The following system error occurred: The following system error occurred: The following system error occurred: The following system error occurred: OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. The following system error occurred: The current operation was cancelled because another operation in the transaction failed. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. '."
Does anyone know how to correct this, or where this error is coming from?
Many thanks,
Edward
hi @Anonymous
On the Power BI Desktop side:
old = OData.Feed("https://d365_instance.api.crm.dynamics.com/api/data/v8.2")
new = OData.Feed("https://d365_instance.api.crm.dynamics.com/api/data/v8.2", null, [Implementation="2.0"])
add this in
, null, [Implementation="2.0"]
Regards,
Lin
Where do I add that? In the instance AP section of dynamics online data import?
What connector are you using to connect to Dynamics 365 CRM? Dynamics 365 (online)?
@Greg_Deckler Thank you for your reply - yes using that, then the web api url ending /data/v9.1/ authenticated with organisational account.
I had been trying to load in account & contact information & used the select related criteria box to select related fields.
Hmm, maybe simplify your query to the bare minimum and then add steps and see what causes it to puke.
You could check the Issues forum here:
https://community.powerbi.com/t5/Issues/idb-p/Issues
And if it is not there, then you could post it.
If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |