In the article, we will learn step by step, how to create a Power BI Report using Microsoft Dynamics 365 CE as the data source.
Alternate link to download Power BI Desktop
And specify it for Web API URL in the Power BI
Right-click Queries section and select new blank query and define two tables as shown below
Now use “Merge Queries” for the main Incident Query and do a left join with these 2 new queries created as shown below.
Thus we saw how easy it is to author a Dynamics 365 CE Power BI Report which is highly interactive and highly customizable in few steps and without writing any single of code.
Stay here for learn, we will post next article for Embedding Power BI Dashboard and Report inside Microsoft Dynamics 365 CE in a few days.