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
- One of the best parts which we check above is Relationships are correctly shown as it is in CDS
- 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
More About This Author
Array
YouTube26 March 2024MS D365 Sales Accelerator Demo: Unravelling Segmentation, Sequences, Assignment, & more – YouTube
YouTube20 March 2024Configuring Mailbox in Microsoft Dynamics 365 CE: Step-by-Step Guide – YouTube
YouTube18 March 2024How to Debug Canvas Apps with the Monitor Tool: Tutorial – YouTube
YouTube18 March 2024How to Launch Native Apps from Canvas Apps: Step-by-Step Tutorial Using Launch Function – YouTube
