Query folding

Concept

Power Query optimization that pushes supported transformation steps back to the data source, such as a database, instead of evaluating them in the Power Query engine. Flat files like CSV and Excel cannot fold.

Title graphic: Query folding (Concept)

Type	Concept
Documentation	learn.microsoft.com/en-us/power-query/query-folding-basics

Articles about Query folding (3)

Освоение query folding в Power BI: переносим вычисления в источник данных
2026-08-28 · Mirko Peters
При работе с Power BI мало что раздражает сильнее, чем обновление данных, которое тянется целую вечность, или, что хуже, падает с ошибкой из-за нехватки ресурсов…
Mastering Query Folding in Power BI: Push the Work to Your Data Source
2026-08-28 · Mirko Peters
When working with Power BI, few things are more frustrating than watching your data refresh take an eternity, or worse, watching it fail outright because it ran out…
Mastering Plain-English Queries with Microsoft Copilot Studio
2026-08-28 · Mirko Peters
Welcome back, data enthusiasts! Today, we are diving deep into a topic that is fundamentally transforming how organizations interact with their data stacks. If you …

Glossary

Community wiki

Short info above, community knowledge below: add practical tips, examples or corrections. New contributions are reviewed first; trusted members publish directly.

Experts and companies for this topic

Nobody has listed this topic yet. Add it to your profile.

Sources

Documentation: learn.microsoft.com/en-us/power-query/query-folding-basics
Feed for this topic (RSS): entity/query-folding/feed.xml
Articles on this topic: 3

Maintained by Mirko Peters (Microsoft MVP) · Last updated: 2026-11-03