Parag Chapre

Create a Leave and Absence Report in Dynamics 365 HR

Spread the love

Currently, it not possible to modify a Power BI report embedded inside Dynamics 365 Human Resources. There is however, a workaround to create such a report. In this article, we will show you how you can create a Leave and Absence report in Dynamics 365 Human Resources. But before we start, we have to understand the functionality of Leave and Absence and the architecture behind it. Below, you can see a diagram to better understand the Leave and Absence architecture in Dynamics 365 Human Resources.

Creating a Leave and Absence report in Dynamics 365 Human Resources

In order to create a Power BI report, we need the following data entities as pictured below:

If you look at the report below, you can see that the data is coming from the entities Worker, Leave type, Leave plan, and Leave bank transactions. These entities are already available in the CDS.

Dynamics 365 Human Resources – Leave and Absence (Current Balance Analysis)

Creating a Power BI report

In order to make a Leave and Absence report, we need to work with Power BI. These are the steps you need to follow:

  1. Open the Power BI desktop
  2. Click on Home > Get Data > Common data service > Select the entities mentioned in the screenshot below
    Leave and Absence report screenshot of data entities
  3. Add a relation between the entities
    relations in entities leave and absence
  4. Add the Matrix Visual to the report. This is how you do it:
    • Add name and Personnel number to rows
    • Add leave type to columns
    • Add amount to values

Once this is done, your visual should look like this:

Visual of Power BI data report for D365 HR leave absence report

   5. We can add more visuals to the report if we like. This is how you do it:

Axis: Leave type, Values: current balance.

more visuals to the report in D365 HR leave

Once you have followed the steps above, your report should be ready. It should look like this:

Power BI report for Leave and Absence Microsoft

You can even add more filters to your report. This way, you can create many visuals, making your report even better. If you compare the report in Dynamics 365 HR and the report created based on CDS, then there is not much difference in the data.

Report difference between CDS and D365 HR Power BI

Embed report in Dynamics 365 HR Workspace

  1. Publish report to Power BI workspace
  2. Go to report, click on Share > Copy the Secure Embed code
  3. Go to Dynamics 365 HR Home > Add new page > Website > Add name and use Secure Embed code from Power BI

This is how you can create a Power BI report in Dynamics 365 Human Resources. If you like the article, feel free to share it work others who might find it helpful. If you have any questions, feel free to get in contact with me.


  1. Hi, this is a great report thanks – do you know if it is possible to create a report showing leave enrollment end date and position end date? I can report on both end dates separately, but can’t get them both showing on the same report because Power BI can’t detect the relationships between the fields. many thanks, Tom

  2. I just wanted to say thank you for your blog. It was the best piece I read today. I will be looking forward to reading more of your content.

Leave a Reply

Your email address will not be published. Required fields are marked *