web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

How to link cdm_leaverequestdetail to cdm_leavetypereasoncode

(0) ShareShare
ReportReport
Posted on by 40

Hi 

I'm trying to create a power bi report that shows leave request details but filtered on the leave reason code, but I'm struggling to link the two tables together.

Can you please help

I have the same question (0)
  • Suggested answer
    Parag Chapre Profile Picture
    12,254 Most Valuable Professional on at

    Hi Martin,

    Please check this link for the relationship model.

    docs.microsoft.com/.../hr-developer-entities

  • Martin Booth Profile Picture
    40 on at

    Hi Parag

    Thanks for the diagram.  I still can see how to link the two specific tables together from the diagram, have I missed something?

  • Verified answer
    Parag Chapre Profile Picture
    12,254 Most Valuable Professional on at

    Hi Martin,

    The link is cdm_leaverequestdetail > cdm_leavetypeid and cdm_typeid from cdm_leavetypereasoncode

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 545 Super User 2026 Season 1

#2
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 408

#3
Adis Profile Picture

Adis 267 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans