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...
As an update, I tested with a different Project Online instance and it worked. I was able to get the whole Projects table using http://PWAURL.com/_api/ProjectServer/Projects() then expand the ProjectResources table in the query editor. It works in one instance but not the other. Both are configured the same way as far as I can tell.
Hello David_Howe ,
That's good to know the expand works on one instance. For the other instance is there an error on the expand in Power BI? It might be data related.
Paul
- Ok, great. Will do. Thanks!
Hello David_Howe ,
That's a tricky one, probably something you'd need to raise with Microsoft via your M365 admin portal to see if it is something that can be resolved in the data. It might be a certain resource type that is missing some data to enable the Odata expand.
Paul
- Yes, Paul. The error message is as follows: 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
