Forum Discussion

kberg87430's avatar
kberg87430
New Member
8 years ago

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 TaskPerece...
kberg87430's avatar
kberg87430
New Member
8 years ago

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's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

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