All checks
Power QueryReliabilityLow

JSON expanded without a fixed schema

"JSON expanded without a fixed schema" is one of the reliability checks Auditabi runs on a Power BI semantic model. n query(ies) read JSON and expand records without naming the fields. It is a low-severity finding: hygiene and maintainability, worth fixing when you next touch the object. Expand an explicit list of fields so a change in the payload fails loudly instead of silently.

What is detected

n query(ies) read JSON and expand records without naming the fields. When the API adds or removes a field the column set changes silently, and visuals lose their binding.

Why it matters

Hygiene and maintainability. Fix when touching the object.

How to fix it

Expand an explicit list of fields so a change in the payload fails loudly instead of silently.

Does your model fail this check?

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

Audit a model

More Power Query checks