SOLVED

How do I report (Power BI) on vacation days in Resource Calendar (Project Online)

%3CLINGO-SUB%20id%3D%22lingo-sub-2139924%22%20slang%3D%22en-US%22%3EHow%20do%20I%20report%20(Power%20BI)%20on%20vacation%20days%20in%20Resource%20Calendar%20(Project%20Online)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2139924%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI'm%20trying%20to%20report%20on%20remaining%20vacation%20days%20in%20Power%20BI%20when%20connected%20to%20Project%20Online.%26nbsp%3B%3C%2FP%3E%3CP%3EResources%20report%20their%20requested%20vacation%20days%20via%20their%20timesheet%2C%20and%20once%20approved%2C%20their%20resource%20calendar%20gets%20updated%20automatically.%20We%20have%20a%20resource%20field%20which%20shows%20the%20annual%20entitlement%2C%20so%20as%20these%20entitlement%20days%20are%20consumed%20I%20want%20to%20then%20report%20on%20the%20remaining%20days%20that%20each%20resource%20would%20have%20available.%20However%20I%20am%20really%20struggling%20to%20find%20the%20right%20data%20in%20the%20tables%20that%20would%20provide%20me%20with%20the%20approved%20vacation%20days%20taken%2Fbooked%20so%20far.%26nbsp%3B%20%26nbsp%3BAny%20advice%20greatly%20appreciated.%20Thanks%3CBR%20%2F%3EAlison%3C%2FP%3E%3CP%3E%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2142234%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20report%20(Power%20BI)%20on%20vacation%20days%20in%20Resource%20Calendar%20(Project%20Online)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2142234%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F176520%22%20target%3D%22_blank%22%3E%40Alison%20Howes%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%0A%3CP%3EThis%20data%20is%20available%20in%20the%20ProjectServer%20API%20(_api%2FProjectServer).%20For%20example%3A%3C%2FP%3E%0A%3CP%3E%7BpwaSiteUrl%7D%2F_api%2FProjectServer%2FEnterpriseResources('%7BresouceGuid%7D')%2FResourceCalendarExceptions%3C%2FP%3E%0A%3CP%3EReplace%20the%20%7BresouceGuid%7D%20with%20the%20resource%20GUID%20for%20the%20resource%20you%20want%20to%20check.%3C%2FP%3E%0A%3CP%3EPaul%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi,

I'm trying to report on remaining vacation days in Power BI when connected to Project Online. 

Resources report their requested vacation days via their timesheet, and once approved, their resource calendar gets updated automatically. We have a resource field which shows the annual entitlement, so as these entitlement days are consumed I want to then report on the remaining days that each resource would have available. However I am really struggling to find the right data in the tables that would provide me with the approved vacation days taken/booked so far.   Any advice greatly appreciated. Thanks
Alison

  

2 Replies
best response confirmed by Dale Howard (MVP)
Solution

Hello @Alison Howes ,

This data is available in the ProjectServer API (_api/ProjectServer). For example:

{pwaSiteUrl}/_api/ProjectServer/EnterpriseResources('{resouceGuid}')/ResourceCalendarExceptions

Replace the {resouceGuid} with the resource GUID for the resource you want to check.

Paul

@Paul Mather Thanks Paul, I'll check that out! :) 
Alison