Leave Plan not appearing when reporting on Dynamics 365 for Talent

[Anonymous]

Hi all,

Apologies if this isn't the right place, I wasn't sure what forum this problem applied most to. 

I've made a report in the latest version of Power BI desktop, and it pulls data from the Common Data Service that our production instance of Talent sits on. It displays the leave plans that are associated with a person via the cdm_leaveenrollment table. I've set up a relationship from the cdm_worker table to the cdm_leaveenrollment table, and from there to the cdm_leaveplan table. It returns every plan associated with the users by displaying the cdm_name field in the cdm_leaveplan table, and the issue is that it doesn't display some people's Annual Leave plan. I've checked if they have an Annual Leave plan associated with them in Talent and yes, they're on it. It's a strange one alright, any ideas? 

[mwegener]

Hi @Anonymous ,

could you give an overview of you model? (Screenshot)

Check the relations and the relation key values.

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

[Anonymous]

Hi,

Apologies for the delayed response! Here's the three tables in my data model that apply here: 

A worker is associated with a leave enrollment record by their worker id, and the leave enrollment record is associated with a leave plan record by the leave plan ID. I need to show all workers' employee numbers, their full names and the name of the leave plan (at the end I will use a page-level filter to only show the annual leave plans, but I'd like to get it working first).

It's successfully showing all of the associated leave plans, just not the annual leave plans for some people. I've checked and they do indeed have annual leave plans in the Talent system.

Any help is greatly appreciated!

[Anonymous]

Just an addition:

I used Advanced Find to try and view all of the leave plans associated with the worker's leave enrollment records. I chose a worker whose Annual Leave plan wasn't showing up, and out of the 10 enrollment records, it only returned 8 plans:

If I still can't figure it out, I may contact Microsoft support about this as I am stumped!