Power QueryReliabilityLow
Excel source read by sheet position
"Excel source read by sheet position" is one of the reliability checks Auditabi runs on a Power BI semantic model. n query(ies) read an Excel sheet by name or index rather than a named table. It is a low-severity finding: hygiene and maintainability, worth fixing when you next touch the object. Format the range as a table in Excel and read that table by name.
What is detected
n query(ies) read an Excel sheet by name or index rather than a named table. Inserting a row above the header, or renaming the sheet, breaks the refresh.
Why it matters
Hygiene and maintainability. Fix when touching the object.
How to fix it
Format the range as a table in Excel and read that table by name.
Does your model fail this check?
Free static audit with the exact objects, no account, nothing stored.