Forum Discussion

Madan kumar's avatar
Madan kumar
Copper Contributor
May 07, 2018

Project Web App (Project Online) Connectivity to Power BI through OData

I am trying to connect my Project plan which is in Project online (PWA) to Power BI through OData for custom PBI reporting of Project plan.   I can get all the table's for PBI Visualisation. I am u...
Karl STEWING's avatar
Karl STEWING
Copper Contributor
May 10, 2018

Hello -

 

There is no direct link that can be established between Resources and Tasks. You could use the Assignments table to do that (to see resource assignments against tasks).

 

Madan kumar's avatar
Madan kumar
Copper Contributor
May 10, 2018

Hi Karl,

 

Thanks for your reply, I did tried i can now bring in the resources through Assignment table but i am unable to see the user specific tasks on my report.

 

There is a relationship between two table Assignment table and Task Table (Unique Value is Task Id)

 

E.g. Task 1 is assigned to User A, Task 2 to User B and Task 3 to User C, When the select User A it still shows me all the tasks. I have to see Task 1 as per my filter selection.

  • Ian Bruckner's avatar
    Ian Bruckner
    Iron Contributor
    May 10, 2018

    Have you linked assignments to resources on ResourceId yet?

    • Madan kumar's avatar
      Madan kumar
      Copper Contributor
      May 10, 2018

      Yes I Did, There is a relationship between the two tables

      • Karl STEWING's avatar
        Karl STEWING
        Copper Contributor
        May 10, 2018

        The link chain is the following:

        TaskId (Tasks) <-> TaskId (Assignments)

        ResourceId (Resources) <-> ResourceId (Assignments)

         

        Do you have both?

         

         

Resources