Forum Discussion

Alison Howes's avatar
Alison Howes
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's avatar
    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's avatar
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's avatar
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 :facepalm:

Resources