top of page

D365 HR | Chapter 37: Cooking with Virtual entities.

Actualizado: 20 ene 2021

Ok, great. In the past article, I showed you how to turn on integration with CDS Dataverse from D365 HR, but now I want to complete the entire process and show you how to enable virtual entities tables in your environment. Follow the steps, they are a LOT, I know. But is worthy, believe me - I know you do 😜.

👓 First thing to do: Enable the Feature: Virtual Entity support in HR/CDS. Go here EN D365 HR | Chapter 36: DataVerse tables and Integration. ( to complete the steps. Once you've done it, you are ready for the following level.


✍️ Second thing to do: Register the D365HR Instance in Microsoft Azure. How? See steps below;

  1. Go here: Home - Microsoft Azure and log in.

  2. Once you are logged, go to App registrations. And select New registration.

3. You will see that a new page appears, with the following fields:

In this step, you will need to complete, name, and redirect URL - the URL of your D365 HR Instance - then select Register.

Microsoft recommends keeping the name simple, I totally agree with that. I used D365 HR Virtual Entities as the name.

4. Once you've done all of this, the Azure Portal will show you the registration information. Please save Application (client) ID, you will need it later on.

5. In the menu on the left side, select Certificates and secrets, as shown below. Select New client secret, a tab will pop up. Complete the fields and select Add.

🚨 WARNING 🚨: Take note of the secret's value. You'll never see it again, and you will need it in order to complete other processes (I know, a lot of steps, is totally worth it, I promise).


🔌 Third thing to do: Install D365 HR Virtual Entity App.

  1. Go here Power Platform admin center.

  2. You might have a few environments, select the one associated with D365HR. Go to Resources, and select Dynamics 365 Apps.

From the list - see image below - select Dynamics 365 HR Virtual Entity, and select Install.

A new tab will open, you will need to select your environment once again, agree on terms of service and, select Install (again). It can take a few minutes.


💾 Fourth thing to do: Configure the virtual entities tables data source.

  1. Go to Power Platform admin center.

  2. Select the environment associated with D365 HR. Select the URL from this instance.

  3. Solution Health Hub will open - see image below - select Advanced Find (filter icon)

4. You will need to look for Finance and Operations Virtual Data Source Configurations, and after select Results. Select the Microsoft HR Data Source record and complete the fields with the information required.

  • Target URL: The URL of your D365 HR Instance. I made a horrible mistake here pasting the entire URL for the tenant. Make sure it looks something like this: 8f4d-4891-b174-bf83d948ed0c/

  • Tenant ID: Azure AD tenant ID

  • AAD Application ID: the one we create in the second phase of this process (D365 HR Virtual Entities, for example).

  • AAD Application Secret: client secret.

5. Save and Close.