Forum Discussion

CuriousProjectUser's avatar
CuriousProjectUser
Brass Contributor
Aug 08, 2025

Assignments - inconsistency oData-feed and PWA-GUI?

Dear all,

we tried to identify all user resources in our Project Online environment that don't have an assignment, hence not are assigned to any task in any project.

Idea was to use the Project Online oData feed ".../_api/projectdata", query the table "Assignments" for resources included and join with table "Resources" on ResourceId to get all resources that are not referenced in the table "Assignments". The result was looking reasonable.

However, cross-checking some of the resources that shouldn't have assignments with the data in PWA-GUI, via page Resources (select resource and display assignments) showed that for some of those, individual assignments are shown in the PWA-GUI. 

Could you help me to get my head around this? Did we look in the right place to find resources without assignments? In theory and my understanding, the table "Assignments" should be consistent with what is shown in the PWA-GUI.

We already checked for publish status of the relevant project, the assignment observed had been published 3 days ago.

Kind regards,

Petter

1 Reply

  • RatanPushp's avatar
    RatanPushp
    Brass Contributor
    Aug 18, 2025

    Hello CuriousProjectUser​ ,

    Try reversing your approach, first consider Resources table and join it with Assignments table to fetch resources list with assignment eq 0.

    Moreover, you may also use Power BI report content pack to validate OData of Project Online Assignment, Resources, Projects, etc.. 

    https://github.com/jaduong/Project-Power-BI-Content-Packs/blob/master/Microsoft%20Project%20Online%20Power%20BI%20Content%20Pack.pbit

    Hope this helps you!

    Regards,

    Ratan Pushp

Resources