Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Manage relationships

Hey everyone,

 

I've received a PBI file with tables who are linked together in a circle instead of relationships from one central table who is linked to the other tables. And secondly, the relation between Dump and TechniekerID is many-to-one and the relation between TechniekerID and Contractenkoppel is one-to-many. So the relation between Dump and Contractenkoppel is very fragile. 

 

Is there a way to solve this so you get a reliable model, and thus reliable data when you combine those tables in a graph?

 

Need Help

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    5 years ago

    Anonymous Hmm, well real world data is messy and often does not conform to star schema designs. What you have there looks to be the classic solve for a many-to-many relationship between two fact tables essentially. Generally when you see that design you want both of those relationships to the bridge table to be Both and I don't see that it would cause a problem if you did that.