ModelModelingLow
One-to-one relationship
"One-to-one relationship" is one of the modeling checks Auditabi runs on a Power BI semantic model. n relationship(s) are declared one-to-one. It is a low-severity finding: hygiene and maintainability, worth fixing when you next touch the object. Merge the two tables in Power Query, unless the split exists for security or refresh reasons.
What is detected
n relationship(s) are declared one-to-one. Two tables in a one-to-one relation are one entity split in two: every query pays a join for nothing.
Why it matters
Hygiene and maintainability. Fix when touching the object.
How to fix it
Merge the two tables in Power Query, unless the split exists for security or refresh reasons.
Does your model fail this check?
Free static audit with the exact objects, no account, nothing stored.