The field 'cdi_eventchildevents' already exists in the record.

[sboulanger]

Hi,

When i'm trying to connect to my CRM with the sales manager package I got the error : The field 'cdi_eventchildevents' already exists in the record.

Anyone also had  this problem and know how to solved?

Thank you

[v-caliao-msft · Accepted solution]

@sboulanger please try to connect to CRM by using OData Service

In CRM properties this is the URL:

https:// <tenant> .crm4.dynamics.com/XRMServices/2011/Organization.s​vc

In Power BI, get data, CRM Online the example of the URL is:
https:// <tenant> .crm4.dynamics.com/XRMServices/2011/OrganizationDa​ta.svc

In stead of copy/paste the URL changed the URL and added "Data" tot "Organization.svc".

Reference
http://community.powerbi.com/t5/Desktop/Unable-to-Connect-to-CRM-online-2016/td-p/30428
http://community.powerbi.com/t5/Integrations-with-Files-and/OData-error-with-Dynamics-CRM-Online/td-...

Regards,

Charlie Liao

[sboulanger]

Hi,

Actually I'm trying to connect to the sales management package and it don't give me any choice on how to connect.

Regards 

[daniellanuza]

hi

I have the same issue, while trying to connect from power BI desktop to SFDC reports

I have no idea about the solution you are mentionning as it does not seem applicable to anything i see

maybe it is not applicable to the SFDC connector?

can you help?

Daniel