Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Anonymous
Not applicable

Leave Plan not appearing when reporting on Dynamics 365 for Talent

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? 

 

issue.PNG

3 REPLIES 3

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.

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast


Anonymous
Not applicable

Hi,

 

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

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
Not applicable

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:

advanced find results.PNGall leave enrollments in query.PNG

 

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

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors