Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
kberg87430
New Member

Microsoft Project Online - PowerBI Desktop - Resource Assignment Report

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?

6 REPLIES 6
wgjunsay
Advocate I
Advocate I

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 !

That worked!  Thank you so much

wgjunsay
Advocate I
Advocate I

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

v-jiascu-msft
Employee
Employee

Hi @kberg87430,

 

Can you share a sample?

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

Microsoft_Project_Online

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

 

Relationships.JPG

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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

March 2024 PBI Gallery Image

Power BI Monthly Update - March 2024

Check out the March 2024 Power BI update to learn about new features.