Skip to content
Menu

Public Everscope rule

Filter applied late

ES-PQ-002version 1.0PQmedium

Rows are filtered only after expansion or calculated-column steps.

What this rule checks

Rows are filtered only after expansion or calculated-column steps.

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

Why this is a risk

Late filtering can increase source transfer and transformation cost while reducing folding opportunities.

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

How to resolve it

  1. Move row selection as close to the source as connector semantics safely allow.
  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