Relationship columns with different data types
"Relationship columns with different data types" is one of the reliability checks Auditabi runs on a Power BI semantic model. n relationship(s) join columns of different data types. It is a critical finding: it breaks refresh, returns wrong numbers or exposes data, so it should be fixed before publishing. Align both key columns on the same type (ideally int64) in Power Query.
What is detected
n relationship(s) join columns of different data types. Power BI converts on the fly, matches can fail silently and the join cannot use the fast path.
Why it matters
Breaks refresh, returns wrong numbers, or exposes data. Fix before publishing.
How to fix it
Align both key columns on the same type (ideally int64) in Power Query.
Reference
Tabular Editor BPA: Relationship columns should have the same data type
Does your model fail this check?
Free static audit with the exact objects, no account, nothing stored.