cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

Connect Power BI to Microsoft Dynamics CRM 2011

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

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Connect Power BI to Microsoft Dynamics CRM 2011

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

2 REPLIES 2
Super User
Super User

Re: Connect Power BI to Microsoft Dynamics CRM 2011

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

JonathanReyes Frequent Visitor
Frequent Visitor

Re: Connect Power BI to Microsoft Dynamics CRM 2011

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.