Facing issues in Cardinality (Many- Many)

[Rocky_PBI]

Hi Folks, 

I am facing issue in Data modelling in power BI the issue is the power BI it self taking Many- Many cardinality for Two tables in that Many - Many cardinality I having one popup like " This Relationship has Cardinality Many- Many ,this should be only be used if it is expected that neither column (table 1 and table 2) contains Unique values, and that the Significally different behaviour of Many- Many relationship is understood" but I am changing the cardinality Many-One forcefully power BI unable to process that and I am getting error like " the Cardinality selected isn't valid for this relationship "... Is there any solution for this.. please suggest any solution fo this it's helpful for me and project

Thanks in advance 

[Kaviraj11]

You can create another table(lookup) which will have a unique values from those two tables and then connect both the tables to the Dimension/Lookup Table with Many to One relationships and utilize the column from the lookup table in your visuals. 

Many-to-many relationships in Power BI Desktop - Power BI | Microsoft Learn

[Rocky_PBI]

Hey hi 

Thanks for the answer...i solved by another way... In properties option I am able to do

[sandy_liew]

Hi there, could you please share how do you resolve the above issue?