Text converted to number or date without a culture
"Text converted to number or date without a culture" is one of the reliability checks Auditabi runs on a Power BI semantic model. n query(ies) convert text to a number or a date without specifying the culture. It is a medium-severity finding: the model still works, but results are wrong in some filter contexts, slow, or fragile under change. Pass the culture explicitly, for example Table.TransformColumnTypes(source, {{"Date", type date}}, "fr-FR").
What is detected
n query(ies) convert text to a number or a date without specifying the culture. The result depends on the locale of the machine that refreshes: 03/04 is March in one place and April in another.
Why it matters
Wrong in some filter contexts, slow, or fragile under change. Fix in the next iteration.
How to fix it
Pass the culture explicitly, for example Table.TransformColumnTypes(source, {{"Date", type date}}, "fr-FR").
Does your model fail this check?
Free static audit with the exact objects, no account, nothing stored.