Link between Worker and SystemUser in Common Data Service

(0) Share

Report

Posted on by Jon Hacking

Hi,

We've recently implemented Dynamics for Talent and are looking to map it to our other Dynamics reporting using the Office 365 log-in information. I can see this is stored in the SystemUser entity in Dynamics for Talent but cannot see where the link between that entity and Worker is.

Any help is appreciated

Cheers,

Jon

I have the same question (0)

All responses (4)

Answers (2)

Sort by

Community Member on at

Like
a
(0)

Report
Copy link

Link copied!

Could you help?

Was this reply helpful? Yes No
Verified answer

André Arnaud de Cal... 306,230 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Jon,

There is an entity called "User to person relationship" (DirPersonUserEntity). This is having the link between the user and the worker.

Was this reply helpful? Yes No
Jon Hacking 40 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks Andre, I can't currently see this entity in the list using the CDS connector in PowerBI. Is it available by default or do I have to expose it?

Was this reply helpful? Yes No
Verified answer

Agne Petkute Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hello Jon,

There is currently no relation between Users in HR and Workers in CDS.

However, you can find this information in PersonUser entity in the DMF (System administration -> Excel workbook designer), as mentioned in a previous comment.

Kind regards,

Was this reply helpful? Yes No