Project online, roll up of projects

[Anonymous]

I am trying to run a report with all the projects listed out and the respective sub projects/tasks grouped under the parent project. However, the way project lists the project and the parent project it only goes up one level per row. 

This results in a lot of repeated parent projects. 

I noticed it behaves this way in the content pack and the web app. 

Has anyone figured out the best way to perform this?

Thank you,

Rick 

[v-jiascu-msft]

Hi Rick,

What is the result you'd like to have? Since the content pack is pre-designed, I would suggest you retrieve the Project Online data into Desktop and manipulate it yourself. Please refer to Accessing-Project-Online-Data-from-Desktop and Filtering-OData-queries-result-Project-Online.

Best Regards,
Dale

[Anonymous]

Dale,

I am using Power BI Desktop, but I am using the content pack to see how it pulled the data as there are many tables to get different information.

Because of the way Project online stores "projects" or the way the Odata is feed to PowerBI a "project" will have a row that lists the main project as ProjectName, ParentTask and TaskName. Also if there is a project created under a main project then there will be a row with that sub project as ParentTask and TaskName.

This causes repeating of data in the report, doubling the amount of real hours that report should have.

I have attached to redacted pics that show this relationship.

 

[v-jiascu-msft]

Hi @Anonymous,

What's the [TaskActualWork] of the fourth row in the first image? Is it 551.75? 

It seems the data has a total row like below? Isn't it?

ProjectName    ParentTaskName   TaskName
275 Testing      275 Testing           275 Testing
275 Testing      275 Testing           Internal Testing
275 Testing      275 Testing           ... ... others

Best Regards,
Dale

[Anonymous · Accepted solution]

I was able to solve this issue by adding custom fields in Project and enter in the true Parent task and all the next level up projects. 

I