Forum Discussion

sidimm's avatar
sidimm
Copper Contributor
Jul 11, 2025

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...
RatanPushp's avatar
RatanPushp
Brass Contributor
Aug 04, 2025

Hello Sidimm,

Resource utilization report is not part of Power BI report pack and require custom development. Assume, you are looking something similar to below report.

https://www.linkedin.com/posts/ratan-pushp_powerbi-projectonline-projectmanagement-activity-7295710080505630720-QDEV?utm_source=share&utm_medium=member_desktop&rcm=ACoAAARF1oIBYwYyPfvSAIEhai53QlcZqxpF6uk

I hope it is helpful for you!

Ratan Pushp

 

sidimm's avatar
sidimm
Copper Contributor
Aug 05, 2025

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

  • RatanPushp's avatar
    RatanPushp
    Brass Contributor
    Aug 06, 2025

    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

Resources