USERELATIONSHIP on a pair with no inactive relationship
"USERELATIONSHIP on a pair with no inactive relationship" is one of the reliability checks Auditabi runs on a Power BI semantic model. n expression(s) call USERELATIONSHIP on two columns that are not joined by an inactive relationship. It is a critical finding: it breaks refresh, returns wrong numbers or exposes data, so it should be fixed before publishing. Create the inactive relationship between the two columns, or fix the column references in USERELATIONSHIP.
What is detected
n expression(s) call USERELATIONSHIP on two columns that are not joined by an inactive relationship. The measure errors at evaluation time.
Why it matters
Breaks refresh, returns wrong numbers, or exposes data. Fix before publishing.
How to fix it
Create the inactive relationship between the two columns, or fix the column references in USERELATIONSHIP.
Does your model fail this check?
Free static audit with the exact objects, no account, nothing stored.
More DAX checks
- Arithmetic or comparison on a measure that returns text
- Measure returning text in one branch and a number in another
- Share denominator clears a fact-table column instead of the dimension
- "Previous period" window overlaps the current one
- Percentage label built without ×100
- Percentages and amounts summed together