Currently I See all my resources in Resourcecenter, and I Group them by resource department and then by title.Can I see which project they are currently on? So that I can have a total overview that can be grouped by Project and then by Resource Department. Best regards,Marin

Hello Marinpetersen, You can either build a Power BI / Excel report to see this information or from the Resource Center in PWA, select the resources then click the Resource Assignments button - that will then load a grid that shows you what projects the selected resources are working on. Paul

Can I see which Project all of my resources currently are on?

Paul_Mather
MVP
Oct 22, 2019
Hello Marinpetersen,

You can either build a Power BI / Excel report to see this information or from the Resource Center in PWA, select the resources then click the Resource Assignments button - that will then load a grid that shows you what projects the selected resources are working on.

Paul
- Marinpetersen
  Copper Contributor
  Oct 24, 2019
  Hello Paul_Mather
  
  Thank you for your response, I will look into how I can set a report in excel.
  
  I am familiar with the pwa option resource assignments, but I don't want to have to choose which resources to see, and as I understand I have to choose which resources I wanna see and only up to 100, with the resource assignments option, is that correct?
  
  I can try to give an example, I want a simple overview saying how many resources I have, how many I have in which department, and how many are on projects and how many are "loose":
  All resources : 250
  - Department 1: 100
  - - Project 1: 50
  - - Project 2: 20
  - - "Loose": 30
  - Department 2: 70
  - - Project 1: 40
  - - Project 2: 30
  - - "Loose": 0
  - Department 3: 80
  - - Project 1: 40
  - - Project 2: 30
  - - "Loose": 10
  
  Best regards, Marin
  - Paul_Mather
    MVP
    Oct 24, 2019
    Hello Marinpetersen
    
    I would start with the default Power BI Project Online report pack: https://appsource.microsoft.com/en-gb/product/power-bi/pbi_msprojectonline.pbi-microsoftprojectwebapp?tab=Overview
    
    If you want to edit the Project Online Power BI report to customise for your needs, you can get the Power BI file here: https://github.com/OfficeDev/Project-Power-BI-Templates
    
    Or even the report pack for Project Online I created: https://pwmather.wordpress.com/2017/10/31/projectonline-ppm-powerbi-report-pack-v2-bi-reporting-powerquery-dax-office365/
    
    Paul

Forum Discussion

Can I see which Project all of my resources currently are on?