Skip to content
Menu

Public Everscope rule

Table.Buffer used

ES-PQ-001version 1.0PQmedium

A Power Query expression explicitly buffers a table.

What this rule checks

A Power Query expression explicitly buffers a table.

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

Why this is a risk

Buffering can stop query folding and materialise more metadata-source processing than intended.

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

How to resolve it

  1. Remove the buffer unless measured evidence demonstrates that it is required and faster.
  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