In this episode of Kasper On BI we are talking about analyzing dynamics data with Power BI. What data is there in Dynamics? What types of reports would you want to get out of it? What types of calculations are common for these types of reports? Is there any difference between types of Dynamics? What does Dynamics offer out of the box? And what about Dataverse?
We will also look at what the best ways are to get the data out of dynamics, from TDS to Synapse Link and to use Direct Query or not. In the end you will have a good understanding of what it takes to be able to analyze data from Dynamics from Power BI.
The expert on today’s episode is Scott Sewell, he is a member of the Power BI CAT team with a background in working with Dynamics for year. These days he specializes in analyzing dynamics data with Power BI.
This episode is also available as on YouTube here: https://youtu.be/c7VCU4mOQSc
Links mentioned in the episode:
Follow Scott on Twitter: Scott Sewell (@scottsewell) / Twitter
Connect to Dynamics: Power BI connector – Dynamics 365 Customer Insights | Microsoft Docs
Connect to Dataverse: Create a Power BI report using the Dataverse connector – Power Apps | Microsoft Docs and Use Power BI using Microsoft Dataverse data – Power Apps | Microsoft Docs
What is Dataverse: What is Microsoft Dataverse? – Power Apps | Microsoft Docs