Relationship on a date/time column
"Relationship on a date/time column" is one of the performance checks Auditabi runs on a Power BI semantic model. n relationship(s) join on a dateTime column that is not the key of a marked date table. It is a medium-severity finding: the model still works, but results are wrong in some filter contexts, slow, or fragile under change. Join to the date table on its date key, or use an integer date key (YYYYMMDD).
What is detected
n relationship(s) join on a dateTime column that is not the key of a marked date table. Date-time keys have very high cardinality, compress badly and make the relationship slow.
Why it matters
Wrong in some filter contexts, slow, or fragile under change. Fix in the next iteration.
How to fix it
Join to the date table on its date key, or use an integer date key (YYYYMMDD). A fact date joined to a marked date table is the expected pattern and is not reported.
Reference
Tabular Editor BPA: Relationship columns should not be dateTime
Does your model fail this check?
Free static audit with the exact objects, no account, nothing stored.