Power BI Dashboards for Dynamics 365 Finance & Operations via the Common Data Service - Part 3

[Greg_Deckler]

Introduction

Part 1 of this series introduced at a high-level how the BYOD pattern could be implemented in the new world of Dynamics 365, providing a cloud first spin on a common on-premises pattern for reporting on Dynamics data. Part 2 of this series details the first three steps of connecting Dynamics 365 to Power BI via the CDS, namely:

• Creating the CDS Environment
• Creating the Connection
• Customizing the Entity (OPTIONAL)

Part 3 will cover the following topics:

• Creating the Connection Set
• Creating and Running a Project

Creating the Connection Set

Now that we have a CDS environment and a connection to our Dynamics 365 environment defined, we now need to create a connection set between our Dynamics 365 environment and our CDS environment. A connection set defines a relationship between two different data sources that you wish to synchronize or exchange data between. To create a connection, do the following:

1. Navigate to https://admin.powerplatform.microsoft.com/ext/DataIntegration or alternatively, simply go to https://admin.powerplatform.microsoft.com and click on Data Integration in the left-hand navigation.

2. Click on New connection set in the ribbon area to display the New connection set pane

3. Specify a Connection set name that describes your connect set. Next, specify the connection and environment pairs that will comprise the connect set. Finally, select the correct organizations for each connection. After filling in the information, click the Save button.

4. Your new connect set will appear in the list.

Creating and Running a Project

Now that we have a Connection Set, we next need to create a Project. A Project sets up mappings between entities within the connection and can be configured to run on a schedule to in order to synchronize information between the systems.

1. From the Data integration page, click New project in the ribbon area. The New project pane is displayed.

2. Give your project a Project name. Under Organizations, select the Connection Set that you just created. Click the Create button.

3. Your new project should now appear under Projects. Click on the new project name to edit the project.

4. To map entities, we just first add a task. Click the Add task button. The New task pane is displayed.

5. Give the task a Task Name, select the correct Organization and click the Save button

6. The new task will appear in the list. To create mappings, click > under the Map column

7. Click the Add mapping button in the ribbon area to add a mapping.

8. Choose your Source field, Map type and Destination field. Click Add mapping again.

9. Add as many mappings as necessary. Once complete, click the Save button in the ribbon.

10. It is now time to synchronize our environments. Click Run project. You can then click on Execution History to view the status.

[TeeWright]

Hi Greg, Thanks for the wonderful walkthrough. It is a solution I have been longing for.

I am follow your tutorial but I got stuck when creating the connection set. I could not map the cds i created to dynamic fo.

Thanks for your response in anticipation.

[Greg_Deckler]

@TeeWright  So I am guessing you are getting an issue creating the connection set then? Can you share a screen shot or error message or ?

[TeeWright]

@Greg_DecklerThanks for your reply, I got stuck  when I am trying to connect the Dynamic 365 FO environment to the CDS I created. I could not find the CDS when creating the connection set.

[Greg_Deckler]

@TeeWright  so you don't see anything in your second drop down like this:

[TeeWright]

@Greg_DecklerThe common data service did not appear in the second drop down , only the dyanmcis fo appear. Thanks for your reply.

[TeeWright]

@Greg_DecklerThanks. The connection is working now. We figure it out in-house.