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...

Paul_Mather
Feb 17, 2021
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

MVP

Feb 17, 2021

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

Alison Howes

Copper Contributor

Feb 17, 2021

Paul_Mather Thanks Paul, I'll check that out! 🙂
Alison

Forum Discussion

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