{"id":13167,"date":"2018-10-19T15:33:06","date_gmt":"2018-10-19T10:03:06","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=13167"},"modified":"2022-02-15T16:55:23","modified_gmt":"2022-02-15T11:25:23","slug":"connect-to-the-power-bi-using-common-data-service-cds","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2018\/10\/connect-to-the-power-bi-using-common-data-service-cds\/","title":{"rendered":"Connect to the Power BI Using Common Data Service (CDS)"},"content":{"rendered":"

Introduction:<\/strong><\/h2>\n

The Common Data Service is an integral part of the Business Application Platform, providing secure cloud storage for your app data and integrating with Office 365 and Dynamics 365.\u00a0Common Data Service (CDS) is one of the way to pull data from Dynamics 365. Common Data Service (CDS) enables us to easily build and extend applications with their business data. Using CDS we can directly get option set labels and lookup values without applying any query.<\/p>\n

We will see how we can get data from CRM using Common Data Service for Apps (CDS) in Power BI.<\/p>\n

Now, open your power BI desktop and select \u201cCommon Data Service for Apps (Beta)<\/strong>\u201d under \u201cGet Data<\/strong>\u201d.<\/p>\n

\"Connect<\/p>\n

Now specify your Dynamics 365 URL as Server URL in CDS Contents. If you specify \u201cAdd display column<\/strong>\u201d as false then you will not be able to get status labels and option set labels.<\/p>\n

Note: You will not get option set labels for Multi Select Option Set<\/strong>.<\/em><\/p><\/blockquote>\n

\"Connect<\/p>\n

If you are not already signed in then you need to sign in using your Power BI Credentials.<\/p>\n

After successful signed in, the Navigator window will open showing the list of entities in \u201cCommon Data Model<\/strong>\u201d, \u201cCustom Entities<\/strong>\u201d and \u201cSystem<\/strong>\u201d.<\/p>\n

Common Data Model <\/strong>contains commonly used OOB entities such as accounts, contacts, invoices etc.<\/p>\n

Custom Entities <\/strong>contains custom entities created and entities from project service.<\/p>\n

System Entities <\/strong>contains all the entities from the CRM.<\/p>\n

\"Connect<\/p>\n

Note: You will get status field labels and option set labels only if you have selected entities from \u201cCommon Data Model<\/strong>\u201d as well as from \u201cCustom Entities<\/strong>\u201d.<\/em><\/p><\/blockquote>\n

Now select the entities that you want to pull.<\/p>\n

\"Connect<\/p>\n

The entities selected will be loaded in your power BI desktop. Now you can use entities for making your report. When using Common Data Model and Custom Entities to pull the entities from CRM we get additional fields for status labels as well as for option sets labels. So we can directly use status labels in power BI reports without need of writing a query.<\/p>\n

\"Connect<\/p>\n

Entities can now include calculations and roll ups of related records to allow you to create Excel like formulas on both number and text-based fields.\u00a0Hence you don\u2019t need to use query in custom column to get status labels and option set labels from CRM.<\/p>\n

Conclusion<\/strong>:<\/h2>\n

Common Data Service Provides another way to connect to the CRM and pull data from Dynamics CRM.<\/p>\n

Marketing4Dynamics<\/a> \u2013 Mailchimp and Dynamics 365 CRM integration to plan effective sales strategies, increase sales and improve ROI<\/div><\/div><\/h2>\n