The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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
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
Proud to be a Super User! | |
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?