Connect Power BI to Microsoft Dynamics CRM 2011

[Kristofferaabo]

HI, any tips and tricks on how I get power BI connected to our CR;M database? I done know where to start? 

[Anonymous]

I have look through multiple post trying to connect to either the content pack or directly to CRM throught he deskptop (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.

[ankitpatira · Accepted solution]

@Kristofferaabo PowerBI has in-built content pack for Dynamics CRM check it out here. If you want to connect to database instead you will have to SQL Server connector via power bi desktop. If you are new to the  power bi world and not sure how power bi desktop works I would suggest you start here.