Forum Discussion
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 Onl...
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