In the previous post, we saw how to export CDS data to Azure Data Lake Storage Gen2.
Here we’d see how to write Power BI reports using that data.
Open the Power BI Desktop, and click on Get data
Select Azure > Azure Data Lake Gen 2 and click on connect.
To get the container URL,
Log in to the Azure portal and navigate to the container and click on Properties and copy the URL.
Replace the blob part in the copied URL with dfs
Below is the format of the URL.
replace the account name and the container name.
In case you get the below error
Select the CDM Folder View (beta)
Expand the CDM folder and select the entity.
In case if you get the below error
Once connected we can then create our Power BI report as shown below.
Check the below posts for creating a Power BI report with Dynamics 365 data as the source
Posts on Azure Data Lake
Hope it helps..
One thought on “Use Power BI to analyze the CDS data in Azure Data Lake Storage Gen2”