Forum Discussion

Copper Contributor

Feb 16, 2021

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

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

LisaGaillard
Brass Contributor
Jun 07, 2022
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
Alison Howes
Copper Contributor
Feb 17, 2021
Paul_Mather Thanks Paul, I'll check that out! 🙂
Alison