topic Facing issues in Cardinality (Many- Many) in Developer

Facing issues in Cardinality (Many- Many)

Rocky_PBI — Tue, 19 Dec 2023 03:59:07 GMT

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

Re: Facing issues in Cardinality (Many- Many)

Kaviraj11 — Tue, 19 Dec 2023 20:20:03 GMT

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

Re: Facing issues in Cardinality (Many- Many)

Rocky_PBI — Wed, 20 Dec 2023 03:17:33 GMT

Hey hi

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

Re: Facing issues in Cardinality (Many- Many)

sandy_liew — Wed, 12 Feb 2025 05:39:46 GMT

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