Numeric columns stored as text
"Numeric columns stored as text" is one of the modeling checks Auditabi runs on a Power BI semantic model. Columns whose name or content says number (amount, quantity, id, rate) are stored as text. It is a medium-severity finding: the model still works, but results are wrong in some filter contexts, slow, or fragile under change. Fix the type in Power Query (Changed Type step) as close to the source as possible; keep codes as text only when they carry leading zeros.
What is detected
Columns whose name or content says number (amount, quantity, id, rate) are stored as text. They cannot be aggregated, sort lexically (10 before 9) and cost far more memory.
Why it matters
Wrong in some filter contexts, slow, or fragile under change. Fix in the next iteration.
How to fix it
Fix the type in Power Query (Changed Type step) as close to the source as possible; keep codes as text only when they carry leading zeros.
Does your model fail this check?
Free static audit with the exact objects, no account, nothing stored.