RELATED pointing at an unrelated table
"RELATED pointing at an unrelated table" is one of the reliability checks Auditabi runs on a Power BI semantic model. n expression(s) call RELATED on a table that has no relationship with the table the expression lives on. It is a critical finding: it breaks refresh, returns wrong numbers or exposes data, so it should be fixed before publishing. Create the relationship, or use LOOKUPVALUE with an explicit key match.
What is detected
n expression(s) call RELATED on a table that has no relationship with the table the expression lives on. The expression cannot be evaluated and the object shows an error in every visual.
Why it matters
Breaks refresh, returns wrong numbers, or exposes data. Fix before publishing.
How to fix it
Create the relationship, or use LOOKUPVALUE with an explicit key match.
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