Fact table loaded from Excel or CSV
"Fact table loaded from Excel or CSV" is one of the reliability checks Auditabi runs on a Power BI semantic model. n fact table(s) are loaded from Excel/CSV files. It is a low-severity finding: hygiene and maintainability, worth fixing when you next touch the object. Land the data in a database, lakehouse or at least a governed SharePoint folder with a fixed schema; keep Excel for small reference tables.
What is detected
n fact table(s) are loaded from Excel/CSV files. Column types are inferred, schema drifts when someone edits the sheet, and there is no incremental refresh.
Why it matters
Hygiene and maintainability. Fix when touching the object.
How to fix it
Land the data in a database, lakehouse or at least a governed SharePoint folder with a fixed schema; keep Excel for small reference tables.
Does your model fail this check?
Free static audit with the exact objects, no account, nothing stored.