Forum Discussion
Facing issues in Cardinality (Many- Many)
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
3 Replies
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
Hey hi
Thanks for the answer...i solved by another way... In properties option I am able to do
Hi there, could you please share how do you resolve the above issue?
