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...
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?

       

       

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

        Hi Karl,

         

        Yes the relationship is established , I have attached the screenshot.Please refer the same

         

Resources