Many-to-many relationship
"Many-to-many relationship" is one of the modeling checks Auditabi runs on a Power BI semantic model. n relationship(s) are many-to-many. It is a medium-severity finding: the model still works, but results are wrong in some filter contexts, slow, or fragile under change. Introduce a bridge/dimension table with unique keys, or fix the data so one side is unique.
What is detected
n relationship(s) are many-to-many. Filters propagate through non-unique keys, totals can double count, and the engine cannot use its fastest join path.
Why it matters
Wrong in some filter contexts, slow, or fragile under change. Fix in the next iteration.
How to fix it
Introduce a bridge/dimension table with unique keys, or fix the data so one side is unique.
Reference
Tabular Editor BPA: Avoid many-to-many relationships
Does your model fail this check?
Free static audit with the exact objects, no account, nothing stored.