Forum Discussion
P4W relationships in PowerBi
Hi,
I've got tables loaded from project for the web. The project tasks and project dependencies but I can't see any corresponding relationship between the two.
It the project_tasks table I've tried to expand the Project_dependency_ID column but when I do this I get an error saying that there are duplicates in the project task ID although there are none.
Is there a way to create a relationship between these tables?
4 Replies
you can see attached that the tasks seem to be linking to themselves and not the dependency
Hi, I’ve loaded Project_Tasks and Project_Dependencies from Project for the Web, but can’t see a clear relationship. Expanding Project_Dependency_ID in Project_Tasks gives a duplicate ID error, though there are no duplicates. How can I link these tables properly?
I'd recommend you download the free Project for the Web Power BI template, see link below, and review it as it will cut down your development time. It would also help if you would provide the table names you are trying to relate. We need to ensure you are using the correct table/fields name.
Project-Power-BI-Templates/Project for the Web at master · OfficeDev/Project-Power-BI-Templates · GitHubI was originally using the free template however it didn't match the reporting needs of tracking the baseline tasks with actuals. I can now track the progress of baseline with actuals but in a gantt when trying to do dependencies the relationship doesn't seem to be correct.
I'm using the "msdyn_projecttask" for the tasks and "msdyn_projecttaskdependency" for the dependency, the only link i can see is with the msdyn_predecessor or msdyn_successor task ID in msdyn_projecttaskdependency table. I've used the msdyn_predecessor and linked it to the Project Task ID in msdyn_projecttask table.
However when I go to use this in a gantt it seems to recognize the predecessor as just the same task not a dependency if that makes sense. I originally thought that the Project Task ID and Dependency ID would match as it's in the same format but doesn't seem to match each other.
