SOLVED

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

%3CLINGO-SUB%20id%3D%22lingo-sub-922041%22%20slang%3D%22en-US%22%3ECan%20I%20see%20which%20Project%20all%20of%20my%20resources%20currently%20are%20on%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-922041%22%20slang%3D%22en-US%22%3E%3CP%3ECurrently%20I%20See%20all%20my%20resources%20in%20Resourcecenter%2C%20and%20I%20Group%20them%20by%20resource%20department%20and%20then%20by%20title.%3C%2FP%3E%3CP%3ECan%20I%20see%20which%20project%20they%20are%20currently%20on%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20that%20I%20can%20have%20a%20total%20overview%20that%20can%20be%20grouped%20by%20Project%20and%20then%20by%20Resource%20Department.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20regards%2C%3C%2FP%3E%3CP%3EMarin%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-926536%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20I%20see%20which%20Project%20all%20of%20my%20resources%20currently%20are%20on%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-926536%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F397476%22%20target%3D%22_blank%22%3E%40Marinpetersen%3C%2FA%3E%2C%3C%2FP%3E%0A%3CP%3EYou%20can%20either%20build%20a%20Power%20BI%20%2F%20Excel%20report%20to%20see%20this%20information%20or%20from%20the%20Resource%20Center%20in%20PWA%2C%20select%20the%20resources%20then%20click%20the%20Resource%20Assignments%20button%20-%20that%20will%20then%20load%20a%20grid%20that%20shows%20you%20what%20projects%20the%20selected%20resources%20are%20working%20on.%3C%2FP%3E%0A%3CP%3EPaul%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-942871%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20I%20see%20which%20Project%20all%20of%20my%20resources%20currently%20are%20on%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-942871%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F8793%22%20target%3D%22_blank%22%3E%40Paul%20Mather%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20response%2C%20I%20will%20look%20into%20how%20I%20can%20set%20a%20report%20in%20excel.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20familiar%20with%20the%20pwa%20option%20resource%20assignments%2C%20but%20I%20don't%20want%20to%20have%20to%20choose%20which%20resources%20to%20see%2C%20and%20as%20I%20understand%20I%20have%20to%20choose%20which%20resources%20I%20wanna%20see%20and%20only%20up%20to%20100%2C%20with%20the%20resource%20assignments%20option%2C%20is%20that%20correct%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20can%20try%20to%20give%20an%20example%2C%20I%20want%20a%20simple%20overview%20saying%20how%20many%20resources%20I%20have%2C%20how%20many%20I%20have%20in%20which%20department%2C%20and%20how%20many%20are%20on%20projects%20and%20how%20many%20are%20%22loose%22%3A%3C%2FP%3E%3CP%3EAll%20resources%20%3A%20250%3C%2FP%3E%3CP%3E-%20Department%201%3A%20100%3C%2FP%3E%3CP%3E-%20-%20Project%201%3A%2050%3C%2FP%3E%3CP%3E-%20-%20Project%202%3A%2020%3C%2FP%3E%3CP%3E-%20-%20%22Loose%22%3A%2030%3C%2FP%3E%3CP%3E-%20Department%202%3A%2070%3C%2FP%3E%3CP%3E-%20-%20Project%201%3A%2040%3C%2FP%3E%3CP%3E-%20-%20Project%202%3A%2030%3C%2FP%3E%3CP%3E-%20-%20%22Loose%22%3A%200%3C%2FP%3E%3CP%3E-%20Department%203%3A%2080%3C%2FP%3E%3CP%3E-%20-%20Project%201%3A%2040%3C%2FP%3E%3CP%3E-%20-%20Project%202%3A%2030%3C%2FP%3E%3CP%3E-%20-%20%22Loose%22%3A%2010%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20regards%2C%20Marin%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-943452%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20I%20see%20which%20Project%20all%20of%20my%20resources%20currently%20are%20on%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-943452%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F397476%22%20target%3D%22_blank%22%3E%40Marinpetersen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20would%20start%20with%20the%20default%20Power%20BI%20Project%20Online%20report%20pack%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fappsource.microsoft.com%2Fen-gb%2Fproduct%2Fpower-bi%2Fpbi_msprojectonline.pbi-microsoftprojectwebapp%3Ftab%3DOverview%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fappsource.microsoft.com%2Fen-gb%2Fproduct%2Fpower-bi%2Fpbi_msprojectonline.pbi-microsoftprojectwebapp%3Ftab%3DOverview%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20want%20to%20edit%20the%20Project%20Online%20Power%20BI%20report%20to%20customise%20for%20your%20needs%2C%20you%20can%20get%20the%20Power%20BI%20file%20here%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FOfficeDev%2FProject-Power-BI-Templates%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fgithub.com%2FOfficeDev%2FProject-Power-BI-Templates%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EOr%20even%20the%20report%20pack%20for%20Project%20Online%20I%20created%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fpwmather.wordpress.com%2F2017%2F10%2F31%2Fprojectonline-ppm-powerbi-report-pack-v2-bi-reporting-powerquery-dax-office365%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fpwmather.wordpress.com%2F2017%2F10%2F31%2Fprojectonline-ppm-powerbi-report-pack-v2-bi-reporting-powerquery-dax-office365%2F%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPaul%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

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

3 Replies
Highlighted
Solution

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

Highlighted

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

Highlighted

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-microsoftprojectwebap...

 

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-powe...

 

Paul