Microsoft Project Online - PowerBI Desktop - Resource Assignment Report

[kberg87430]

I am trying to create a Report showing Projects, Tasks, and assigned resources for all tasks that are <100% complete.  I add:

• ProjectManagerName <Custom Field>
• ProjectName
• TaskName
• TaskPerecentComplete

When I add ResourceName, I get a "Missing Relationship Error".  I have tried everything in my non technical mind to establish the correct relationships with no luck.  Can anyone point me in the right direction?

[wgjunsay]

Hello @kberg87430 if this is still an outstanding inquiry, here is how I solved it:

Assuming you will be pulling the "ResouceName" field from "Resources" table, You'll have to bring "Assignments" table to the report. The "Assignments" table links the "Resources" and "Tasks" table together through the fields "ResourceId" and "TaskId".

If you think this comment answered your question please set this as the solution and give a kudos. Thanks !

[kberg87430]

That worked!  Thank you so much

[wgjunsay]

Any updates on this one ? I am having an exact issue! 

[v-jiascu-msft]

Hi @kberg87430,

Can you share a sample?

You can either create it by hand or create it by autodetect.

Best Regards,

Dale

[kberg87430]

Here you go.  I'm basically trying to "join" the Resources and Tasks table.  I'm not overally technical.  I've tried creating relationships between the Task ID and Resource ID but am not apparently doing it successfully

[v-jiascu-msft]

Hi @kberg87430,

No matter whether we can create the relationship or not. What is the relationship between these two tables? Are they connected through Task ID and Resource ID?

Were there any error messages?

Maybe you can try to create a new table and then establish relationships like below.

MiddleTable =
DISTINCT (
    UNION ( VALUES ( 'Tasks(2)'[Task ID] ), VALUES ( Resources[Resource ID] ) )
)

Best Regards,

Dale