Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Matt22365
Resolver III
Resolver III

Relationship building error

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

BI relationships.png

 

I now need to create a link between the task table and timeset table, however when I try I get the following error

BI relationship error.png

 

Is it possible to keep my current links but also create a new relationship?

 

Thanks for your help

 

Matt

1 ACCEPTED 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

View solution in original post

4 REPLIES 4
jthomson
Solution Sage
Solution Sage

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

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.