Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
HI, any tips and tricks on how I get power BI connected to our CR;M database? I done know where to start?
Solved! Go to 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.
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.
@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.