Connect Power BI to Microsoft Dynamics CRM 2011

[Anonymous]

I have look through multiple post trying to connect to either the content pack or directly to CRM throught the desktop (Ver November 2018).

Every post I see refers to Dynamics CRM Online, or the *CRM Online content Pack, but neither is available. Everything I see, is referring to D365.

I can't imagine Microsoft removed data connectivity to one of their own products, so I have to think that I must be doing something wrong.

I tried connecting directly through OData connector, on the desktop, but kept getting this error "Details: "OData: The given URL neither points to an OData service or a feed: ", however I am using the correct URL provided in the CRM under Developer Resources.

[v-yuezhe-msft]

@Anonymous,

What OData URL do you input? The URL should look like: https://XXXX.XXXX.dynamics.com/xrmservices/2011/organizationdata.svc.

In addition, do you have backend database for Dynamics CRM 2011? You can connect to the database in Power BI Desktop instead of using OData URL.

Regards,
Lydia