All checks
Power QueryData SourcesMedium

Whole folder loaded as a source

"Whole folder loaded as a source" is one of the data sources checks Auditabi runs on a Power BI semantic model. n query(ies) read every file of a folder. It is a medium-severity finding: the model still works, but results are wrong in some filter contexts, slow, or fragile under change. Filter the files explicitly by name or extension inside the query, and document what belongs in the folder.

What is detected

n query(ies) read every file of a folder. Any file dropped there — a backup, a temporary copy, a colleague's export — silently joins the dataset at the next refresh.

Why it matters

Wrong in some filter contexts, slow, or fragile under change. Fix in the next iteration.

How to fix it

Filter the files explicitly by name or extension inside the query, and document what belongs in the folder.

Does your model fail this check?

Free static audit with the exact objects, no account, nothing stored.

Audit a model

More Power Query checks