Forum Discussion

barry2099's avatar
barry2099
Copper Contributor
Mar 23, 2023

Project for the Web Summary Tasks and Buckets

I have Summary Tasks (rows) in P4W that do not show a Bucket in the Grid view, however when I connect the Microsoft Project for the Web Power BI Template.pbit to my data, the Projects Tasks data tables have a value in the msdyn_projectbucket column for those Summary Tasks.  Which then shows up in my reports.  I didn't apply a bucket and none show up in Grid view.  How did it get there ?  Where is that value applied to that cell ?

 

TIA

  • Hello barry2099,

    All tasks get a bucket value by default when they are created so it's either the default bucket value from your project, if this is the default board it would be "Bucket 1". Or a bucket value was set for this task before it was made a Summary / parent task. The bucket values are just hidden from the UI for summary / parent tasks but the data is kept in the data verse tables, hence you see this data in the report.

    Paul

  • Hello barry2099,

    All tasks get a bucket value by default when they are created so it's either the default bucket value from your project, if this is the default board it would be "Bucket 1". Or a bucket value was set for this task before it was made a Summary / parent task. The bucket values are just hidden from the UI for summary / parent tasks but the data is kept in the data verse tables, hence you see this data in the report.

    Paul

Resources