Forum Discussion
P4W relationships in PowerBi
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 · GitHub
I 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.
