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 unable to create the relationship between Task table and Resource Table.

 

I see the Resources  I have added in Project Web App and the resources i added against my tasks is not synced.

 

Please let me know if i can get the solution

  • Karl STEWING's avatar
    Karl STEWING
    Copper Contributor

    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

      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

        Have you linked assignments to resources on ResourceId yet?

Resources