Help with an error loading data into PowerBI from Dynamics 365

[Anonymous]

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

[v-lili6-msft]

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

[Anonymous]

Where do I add that? In the instance AP section of dynamics online data import?

[Greg_Deckler]

What connector are you using to connect to Dynamics 365 CRM? Dynamics 365 (online)? 

[Anonymous]

@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.

[Greg_Deckler]

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".