Forum Discussion
Join 2 tables
Hi there,
I'm trying to join these two tables with a 1 to many relationship between these two files but Power BI is forcing me to do a many to many relationship.
And that makes my relationship not interactive like I wanted.
What I mean is that normally I should have a relationship that allows me with an item of the first table to modify the second or the relationship that power creates for me does not really link my tables.
I don't know if you see a way to make this possible in order to have my two tables interactively linked.
Thank you for your help.
Best regards,Power BI will usually force where there is indeed many to many relationships.
Please check your joining link/column, it might not be unique in either case
Regards,
Ritesh
Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau Users
2 Replies
Power BI will usually force where there is indeed many to many relationships.
Please check your joining link/column, it might not be unique in either case
Regards,
Ritesh
Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau UsersHi Eddy-cbre
Thanks for reaching out to us.
>> but Power BI is forcing me to do a many to many relationship
Please check whether there is a many to many relationship in your two tables. If they are not one to many but many to many, then it will be enforced as a many to many relationship.
For more information, see Relationships with a many-many cardinality.
For more information about when to change cardinality, see Understanding additional options.
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
