Get Data using SQL Server Connection of Microsoft dynamics 365 CDS online within Power BI – YouTube

Get Data using SQL Server Connection of Microsoft dynamics 365 CDS online within Power BI and embedding in dynamics 365

Previous Post: Connecting SSMS with Dynamics 365 CRM online and using SQL to Query Data

1. One of the best parts which we check above is Relationships are correctly shown as it is in CDS
2. 2nd is adding lookup, Options field, regarding field all will give Name /Label and values both as separate Fields , for which we need to do some extra work when getting data from Odata.

Table of Contents:

00:00 – Introduction
00:20 – Connect SSMS with Dynamics 365 CRM Onlin
00:39 – Enable TDS EndPoint
00:55 – Connect SQL SERVER of Dynamics 365 CRM
01:48 – Selecting Entities for Model
02:42 – Lookup field in Power BI
03:13 – Optionset in power BI
03:40 – Embed Power BI DashBoard in D365

source