Forum Discussion
manage views on capacity planning view
Hi Hoping for some help I currently use power BI to make capacity charts from all the data in project online. As weve started to roll this out wider in the company the refresh rate of BI has starte...
Hi TonyProctor
Thanks for getting back to me
This sounds similar to what I was thinking as a workaround.
Alternatively I can increase the powerBI schedule refresh rate to every hour but still not quite what im hoping for i.e. Project managers want to be able to make a change to a project and see how that impacts the resource capacity while in discussion with the Resource managers, so waiting for the next refresh to see the impact isnt ideal.
If there was a way to merge the capacity planning tool and the resource assignments tool on to one page it would solve the issue
Really all I need is the details table in the capacity planning tool to show task names. the rest of the detail doesnt matter too much
Thanks
Matt
So you bring up a good point, process-wise; I like to have the PMs/Schedulers use MS Project for their (step 1) demand (Resource Usage) within their schedule, when that is correct then (step 2) close out MS Project, open it back up but select the "Load Summary Resource Assignments". That will let them see the same resources in (Resource Usage) across the entire portfolio.
This process allows them sanity for themselves and then across the portfolio AND no need to wait : )
*Tip: If they're needing to switch or look for other resources they can use the "Build Resources from Enterprise" and use the "Show Resource Availability" to filter.
This process allows them sanity for themselves and then across the portfolio AND no need to wait : )
*Tip: If they're needing to switch or look for other resources they can use the "Build Resources from Enterprise" and use the "Show Resource Availability" to filter.