Join 2 tables

[Eddy-cbre]

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,

[v-xiaotang]

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.

[ribisht17 · Accepted solution]

@Eddy-cbre 

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