Forum Discussion
Join 2 tables
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.