Unable to Connect to CRM online 2016

[JoelF]

Hi, I'm trying to connect to CRM online 2016 from Power BI desktop, and I get a message 'Unable to Connect.  Details: "The field 'regardingobjectid_cdi_unsubscribe' already exists in the record.".  

Can anyone help with this?

[RobJo]

I'm having the same issue/error.
And yes, we have QlickDimensions installed on the same CRM server.... 
And now?

Rob.

[ziffo · Accepted solution]

I am able to connect using "old" OData Service.

Try use

https://<tenant>.crm.dynamics.com/XRMServices/2011/OrganizationData.svc

or

https://<tenant>.api.crm.dynamics.com/XRMServices/2011/OrganizationData.svc

[Greg_Deckler]

@ziffo - I'm able to connect to that end point in the new tenant, however, I had to update my OAuth2 credentials but my refreshes in the Power BI service still fail with the error:

Power BI

Last refresh failed: Wed May 11 2016 07:54:28 GMT-0400 (Eastern Daylight Time)
An error occurred while processing the data in the dataset.Hide details

Data source type:
Data source error:	We're sorry, an error occurred during evaluation.
Cluster URI:	WABI-US-NORTH-CENTRAL-redirect.analysis.windows.net
Activity ID:	5005a467-fd33-49c4-9a4c-6ab148f1d17a
Request ID:	b1e13b25-cdac-73aa-1465-9c55a83efa9c
Time:	2016-05-11 11:54:28Z

[achinm45]

Hi @Greg_Deckler,

I am getting an issue while refresshing reports on online Power BI version.

Reports are refreshing well in Desktop version while it faces problem in online version.

Is your case solved ?

Do we need to make any changes to CRM online ?

Please advise

BR,

Achin

[achinm45]

Hi @Anonymous,

If you are facing same issue with CRM Online, you can read my blog . Its URL is :

https://community.powerbi.com/t5/Community-Blog/CRM-Online-issues-with-oData-and-solution-with-FetchXML/ba-p/82702

Hopefully it helps you !

BR,
Achin

[ziffo]

Hi, 

have you been able to fix the issue? I am facing the same problem. I think it is somehow related to ClickDimensions solution which is installed on CRM. Do you have ClickDimensions?

Thank you

[achinm45]

Hi @JoelF,

Seems you are expanding some field in an entity. After it expands it is resulting into atleast two columns of same name.

Try checking your entities and see the name of fields.

BR,

Achin

[Greg_Deckler]

Well, our CRM Online instance gets updated today so I'll let you know if my dashboard refresh breaks.