Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi
I hope someone can help
I currently have a mixture of relationships between MS project tables which I have been using for a while now, however I am getting an error when I attempt a new relationship.
These are my current relationships
I now need to create a link between the task table and timeset table, however when I try I get the following error
Is it possible to keep my current links but also create a new relationship?
Thanks for your help
Matt
Solved! Go to Solution.
Hi
Thanks for getting back to me
That solution has worked, thank you. I also found another way to enable the task and timeset tables to relate. If you convert the directional arrows from single to both my issue sorted itself
Thanks
Matt
You just need to make the new relationship inactive. If it's not letting you make it at all, temporarily make the existing relationship that's causing the problem inactive, then switch the active relationships around once the new one is in place
Since there are two relations pointing to TimeSet, that would have a conflict between them. Just need to mark one inactive. Will work the same for you, but with solve the problem.
Hi
Thanks for getting back to me
That solution has worked, thank you. I also found another way to enable the task and timeset tables to relate. If you convert the directional arrows from single to both my issue sorted itself
Thanks
Matt
Hi
Thanks for getting back to me.
That has worked, however I found a different solution which also worked, I changed the filter direction from single to both which seemed to allow the task table to interact with the tmeset table.
Thanks
Matt
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 38 | |
| 36 | |
| 33 | |
| 32 | |
| 28 |
| User | Count |
|---|---|
| 129 | |
| 88 | |
| 79 | |
| 68 | |
| 63 |