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

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

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