Forum Discussion
Solved
How do I report (Power BI) on vacation days in Resource Calendar (Project Online)
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 resou...
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
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
Thank you, thats exactly what I've been looking for too! 😉
but alas, I have no idea what this is called in my french langauge environment, there seems to be only one entry for calendar and thats the company one I created, I have real troubles finding the localized regional tables
Paul_Mather Thanks Paul, I'll check that out! 🙂
Alison
