Forum Discussion
Resources mapping using Project (Planner) and MS Power BI template
I have started using Project for the web and the MS Power BI template from MS. And I really like what I am seeing so far. How can I add a Resource Mapping view to the Microsoft Power BI Project for...
Hi Ratan,
This is exactly what I was looking for—thank you! Would you mind elaborating a bit on how you created it? and can it be built in the power BI dashboard.
Thanks again,
Sidi M
Hello Sidi,
This resource utilization report is developed using Project Online data tables, Resource assignments and capacity.
Resource Utilization percentage is calculated by dividing sum of assignment work by sum of resource capacity.
To achieve similar report for Project (Planner) additional customization is required as resource capacity not available in existing solution tables.
Thanks & Regards,
Ratan Pushp