Ambiguous relationship cardinality
"Ambiguous relationship cardinality" is one of the reliability checks Auditabi runs on a Power BI semantic model. A relationship is declared one-to-one or many-to-many where a classic one-to-many was expected, or the cardinality does not match the data. It is a medium-severity finding: the model still works, but results are wrong in some filter contexts, slow, or fragile under change. Model a proper dimension with a unique key, or add a bridge table for a genuine many-to-many, and set the cardinality to what the data guarantees.
What is detected
A relationship is declared one-to-one or many-to-many where a classic one-to-many was expected, or the cardinality does not match the data. Filters propagate in surprising ways and totals no longer add up.
Why it matters
Wrong in some filter contexts, slow, or fragile under change. Fix in the next iteration.
How to fix it
Model a proper dimension with a unique key, or add a bridge table for a genuine many-to-many, and set the cardinality to what the data guarantees.
Does your model fail this check?
Free static audit with the exact objects, no account, nothing stored.