Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.