Dimension without a unique key
"Dimension without a unique key" is one of the modeling checks Auditabi runs on a Power BI semantic model. n dimension(s) have no column marked as a key. It is a medium-severity finding: the model still works, but results are wrong in some filter contexts, slow, or fragile under change. Mark the key column (isKey) and enforce uniqueness in the source or in Power Query.
What is detected
n dimension(s) have no column marked as a key. Nothing guarantees the grain, and a duplicate row in the source silently multiplies the facts joined to it.
Why it matters
Wrong in some filter contexts, slow, or fragile under change. Fix in the next iteration.
How to fix it
Mark the key column (isKey) and enforce uniqueness in the source or in Power Query.
Does your model fail this check?
Free static audit with the exact objects, no account, nothing stored.