Forum Discussion
How to surface Project Online resources added to a project but have no assignments in Power BI
In Project Online, we add resources from our enterprise resource pool to projects using the "build team" functionality. Once the team is built for a project we may or may not assign some or all of those resources to tasks in the project. I want to create a Power BI report that shows all of the resources on a project team regardless of whether they have assignments or not. I can get the resources that have assignments, but I cannot figure out how to surface the resources that are on the project team but do not have assignments.
Hello David_Howe ,
That data is not available in the Odata Reporting APIs, it is available in the CSOM REST API though, for example:
{pwaUrl}/_api/ProjectServer/Projects('{projGuid}')/ProjectResourcesReplace {pwaUrl} with your PWA URL and {projGuid} with the project GUID.
Paul
- Thanks, Paul. So, If I want to surface that in a Power BI report, which type of data source would I choose under "Get Data" to use that CSOM REST API?
