Introduction
In this blog, we will see how to connect Power BI desktop application to Dynamics 365 online.
With the recent release in Dynamics 365(v9.1), all data will be stored in Common Data Service(CDS).
So going forward, It is important to connect CDS for any dynamics 365 operations.
https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/data-platform-intro
Prerequisites
- Dynamics 365 user with sufficient role
- Power BI desktop application.
Steps
- Open the Power BI desktop Application and click on Get Data.
![](https://mihirkadam.wordpress.com/wp-content/uploads/2019/06/image-45.png)
![](https://mihirkadam.wordpress.com/wp-content/uploads/2019/06/image-46.png)
Enter the Dynamics 365 Organization URL
![](https://mihirkadam.wordpress.com/wp-content/uploads/2019/06/image-47.png)
![](https://mihirkadam.wordpress.com/wp-content/uploads/2019/06/image-48.png)
Login with D365 user
![](https://mihirkadam.wordpress.com/wp-content/uploads/2019/06/image-50.png)
![](https://mihirkadam.wordpress.com/wp-content/uploads/2019/06/image-49.png)
Select the required entities
![](https://mihirkadam.wordpress.com/wp-content/uploads/2019/06/image-51.png)
![](https://mihirkadam.wordpress.com/wp-content/uploads/2019/06/image-52.png)
We have successfully connected to Dynamics 365 using CDS connector.
Cheers…….!!!!!! š