Skip to content
Menu

Public Everscope rule

Many row-by-row operations

ES-PQ-004version 1.0PQmedium

A query contains several repeated row-level AddColumn operations.

What this rule checks

A query contains several repeated row-level AddColumn operations.

Everscope evaluates only the metadata needed for this deterministic check. It does not read dataset rows or values.

Why this is a risk

Repeated row evaluation can lengthen refreshes and make transformations harder to review.

In a governed environment this can weaken traceability, operational reliability, or the evidence available to reviewers and auditors.

How to resolve it

  1. Combine compatible steps or move deterministic calculations to a governed source when appropriate.
  2. Validate the change with the accountable owner, rerun the same metadata scan, and retain the before-and-after evidence.

Affected object types

  • power query

Rule history

  1. Version 1.0

    Initial published version.

Introduced on 2026-08-01