May 06 2018 10:42 PM
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
May 10 2018 02:56 AM
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).
May 10 2018 04:29 AM
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.
May 10 2018 05:59 AM
Have you linked assignments to resources on ResourceId yet?
May 10 2018 06:08 AM
Yes I Did, There is a relationship between the two tables
May 10 2018 11:50 AM
The link chain is the following:
TaskId (Tasks) <-> TaskId (Assignments)
ResourceId (Resources) <-> ResourceId (Assignments)
Do you have both?
May 10 2018 08:48 PM
Hi Karl,
Yes the relationship is established , I have attached the screenshot.Please refer the same
May 11 2018 07:47 AM
I'm having trouble envisioning what your actual problem is then. Can you share more about the filter or what the report looks like?