Free-text column kept on a fact table
"Free-text column kept on a fact table" is one of the performance checks Auditabi runs on a Power BI semantic model. n text column(s) on a fact table look like free text (comment, description, note, remark). It is a low-severity finding: hygiene and maintainability, worth fixing when you next touch the object. Remove the column, or move it to a detail table loaded on demand.
What is detected
n text column(s) on a fact table look like free text (comment, description, note, remark). Text on a fact is the most expensive thing VertiPaq stores and it is almost never aggregated.
Why it matters
Hygiene and maintainability. Fix when touching the object.
How to fix it
Remove the column, or move it to a detail table loaded on demand.
Does your model fail this check?
Free static audit with the exact objects, no account, nothing stored.