Date columns stored as dateTime
"Date columns stored as dateTime" is one of the governance checks Auditabi runs on a Power BI semantic model. n visible date column(s) are formatted with a time part (General Date, Long Time…). It is a low-severity finding: hygiene and maintainability, worth fixing when you next touch the object. Format the column as a date (Short Date) and drop the time in Power Query when no time component is needed.
What is detected
n visible date column(s) are formatted with a time part (General Date, Long Time…). The engine then stores one dictionary entry per second and visuals show 00:00:00.
Why it matters
Hygiene and maintainability. Fix when touching the object.
How to fix it
Format the column as a date (Short Date) and drop the time in Power Query when no time component is needed. A dateTime column formatted as a date is not reported: Tabular has no separate date type.
Reference
Microsoft: Reduce the size of a data model — date columns
Does your model fail this check?
Free static audit with the exact objects, no account, nothing stored.