Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

Talent Time Off End Date Field

Posted on by Microsoft Employee

Hi,

I am currently trying to build a report in Power BI for Talent but I am struggling to find the End Date for when an employee is off sick (see below):

pastedimage1581287534705v1.png

I have looked in all the leave entities but I cant seem to find it?

Thanks in advance.

  • Suggested answer
    Agne Petkute Profile Picture
    Agne Petkute on at
    RE: Talent Time Off End Date Field
    The "End date" on the form is a calculated field that currently is not included in any of the Leave Request data entities that exist today. As per previous comment, the best way to see day off requests is to use Leave Bank Transactions Entity which displays information per Transaction Date.
    For other connection options please try collaborating with Microsoft partners as in a standard package data entities are stored in Data Management Framework or Common Data Services. 

    Thank you for using Microsoft Dynamics 365 Communities!

    Agne Petkute

    Support Engineer for Dynamics 365 for Human Resources and Dynamics 365 for Finance 

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Talent Time Off End Date Field

    Hi Christy,

    Unfortunately that won't work for me. The first reason is I need to calculate the occurrences of sickness for a worker. If I did that in the transaction entity, that would be classed as 4 occurrences when in fact its only 1. The second reason is that my customer ideally wants to see this in an consolidate view with an end date so they can clearly see when an worker is expected back...

    It has been an nightmare so far in terms of trying to report off Talent using Power BI. Is there another method to connect to Talent instead of using CDS which will give me an identical view of what I see in the front end?

    Kind regards, 

  • Suggested answer
    Christy OKane Profile Picture
    Christy OKane 45 on at
    RE: Talent Time Off End Date Field

    Hi Jamie,

    This works slightly different in CDS than in Talent.

    If you want to check all the day's someone has been off sick, use the Leave Bank Transactions Entity.

    That entity contains the 'Worker', 'Leave Type' and the 'Transaction Date' (This is the date they are taking off).

    If someone has booked 4 days off sick, this would be stored as 4 different Leave Bank Transactions - with the number of hours taken for each day stored in the same record.

    Hope this helps! :)

    Regards,

    Christy

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,902 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,302 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans