Query diagnostics improvements

Important

This content is archived and is not being updated. For the latest documentation, see Microsoft Power Platform product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.

Enabled for Public preview General availability
Admins, makers, marketers, or analysts, automatically Jan 31, 2021 -

Feature details

One of the most powerful features in Power Query is the ability for it to take relational operations (grouping, filtering, and more) and pass to the data source the ones that it knows how to handle. We call this folding, and it allows users to be able to avoid retrieving data that they don’t want to, which immensely speeds up processing.

We're now previewing step folding indicators in Power Query Online. These indicators will allow you to understand the steps that fold or not. When you make a change that breaks folding, it'll be obvious. This allows you to resolve issues more quickly and easily, avoid performance issues from the start, and have better insight into your queries.

A depiction of a query where after initially connecting to source, steps fold.

See also

Step Folding Indicators for Power Query Online (blog)