Forum Discussion

Adrian Adam's avatar
Adrian Adam
Copper Contributor
Aug 16, 2023

PftW timephased data and where to find in dataverse

HI all

 

I am looking for the PftW timephased data of tasks/ assignments in dataverse. So the exact work value for a resource on a particular day. You can access it via the  new "Assignment View" in the usual interface: 

But the question is, where to find this data in dataverse to use it e.g. in a PowerBI  report?!

Paul Mather once did a nice blog post about how to extract this from a JSON piece in the Resource Assignment entity from column "msdyn_plannedwork". --> Link to Post 

But this only works for future work which has not already been completed. Because in the moment some work is completed (as the task is progressing) this part of the timephased data is erased from this JSON piece. So there must be some other place to get this info from as PftW also is able to display this in the new Assignment View. 

Thanks for you help. 

 

 

No RepliesBe the first to reply

Resources