All checks
Power QueryReliabilityMedium

Python or R script inside a query

"Python or R script inside a query" is one of the reliability checks Auditabi runs on a Power BI semantic model. n query(ies) run a Python or R script. It is a medium-severity finding: the model still works, but results are wrong in some filter contexts, slow, or fragile under change. Move the computation to the warehouse or a notebook that writes a table, and let Power Query read the result.

What is detected

n query(ies) run a Python or R script. The refresh then depends on a runtime installed on the machine or the gateway, which is the first thing to break after an update.

Why it matters

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

How to fix it

Move the computation to the warehouse or a notebook that writes a table, and let Power Query read the result.

Does your model fail this check?

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

Audit a model

More Power Query checks