How to make to active many relationship in power bi desktop

[Anonymous]

i am trying to make active relationship but i am unable to make  many to many relationship  .please refere screen shot 

i am getting below  error screen while trying to make two active relationship 

any idea how to make  active two relationship  ?

[Mohammad_Refaei · Accepted solution]

This is not an error... it is a warning.

If you want to proceed with the relationship activation just check the box

P.S. Be careful of the bidirectional relationships

[v-luwang-msft · Accepted solution]

Hi  @Anonymous ,

The many-to-many relationship causes tons of issues, and that is why it is called a weak relationship too. Most of the time, it can be resolved with creating a shared dimension and creating one-to-many relationships from the shared dimension to the fact tables. AVOID this type of relationship in your model.

sample:

before:

turn to:

To learn more details,refer:

https://radacad.com/many-to-one-or-many-to-many-the-cardinality-of-power-bi-relationship-demystified 

https://community.powerbi.com/t5/Desktop/Unique-values-from-two-columns/m-p/468317#M217488 

Wish it is helpful for you!

Best Regards

Lucien

[Mohammad_Refaei · Accepted solution]

This is not an error... it is a warning.

If you want to proceed with the relationship activation just check the box

P.S. Be careful of the bidirectional relationships