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 t...
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}')/ProjectResources
Replace {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?
- Thanks again, Paul. I tried using the Odata connection but keep getting the following error: "Unable to connect. Details: We couldn't parse OData response result. Error: A value without a type name was found and no expected type is available. When the model is specified, each value in the payload must have a type which can be either specified in the payload, explicitly by the caller or implicitly inferred from the parent value."
If I remove the '{ProjGuid'}/ProjectResources from the end of URL and just use {pwaUrl}/_api/ProjectServer/Projects(), I get the full Projects table, but then if I try to expand the ProjectResources table, I get the same error. Any ideas what may be causing this?
