TRENDING

TECHNOLOGY NEWS FROM AROUND THE WORLD

→
Power Query folding: why are transformations running locally?
Business Intelligence · 2026
Business Intelligence

Power Query folding: why are transformations running locally?

Analyze whether Power Query transformations execute at the source, and what that means for speed and correctness.

Yazılımcının GünlüğüPublished: Nov 16, 20263 min read

What query folding means

With a SQL source, Power Query can translate certain filters, projections and transformations into the source system's native query language. That process is query folding. Full folding leaves most computation at the source; partial folding offloads only supported operations. A flat-file source such as CSV does not have a comparable database query engine to accept the transformations.

Step choices can shift processing costs

On a large orders table, filtering by date and selecting required columns before invoking a custom function is often more efficient than loading everything first. A transformation unsupported by the connector can become a folding boundary and move more work to the local engine. The optimizer may reorder some steps, however, so the visible sequence is not proof of the actual execution plan.

How to verify folding

Where supported, inspect View Native Query, query plan indicators and Power Query diagnostics. Look for relevant WHERE predicates and selected columns in the SQL sent to the source. Compare performance using similar data volumes, cache conditions and server load. Do not infer folding solely from whether a preview looks fast; previews may sample data.

Folding does not guarantee correct business logic

Moving work to a SQL engine can reduce processing time, but an incorrect JOIN, timezone conversion or date filter can still produce bad totals. Keep a small validation dataset with negative cases and boundary conditions. A successful refresh is weaker evidence than reconciliation between the source data and the report's business measures.

0 reads

Comments

0 real comments

No real reader comments yet.

✎ Write a comment

Comments are reviewed before publication.