Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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,
Solved! Go to Solution.
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
Hi @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.
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
User | Count |
---|---|
136 | |
73 | |
73 | |
58 | |
54 |
User | Count |
---|---|
194 | |
95 | |
63 | |
63 | |
51 |