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

Resources