Query folding

Hi powerbidev123,

In Power Query, the process in which a transformation step that converts into a native query and pushes to the data source for execution is called Query Folding.

Query Folding can be seen in the Applied Steps where you have an option to View the Native Query. 

This can be seen when the data source is SQL Database.

Refer below Microsoft References for more details - 

Query folding guidance in Power BI Desktop - Power BI | Microsoft Learn

Understanding Query Evaluation and Query Folding in Power Query - Power Query | Microsoft Learn

💡 Helpful? Give a Kudos 👍 — keep the community growing
✅ Solved your issue? Mark as Solution ✔️ — help others find it faster

Best regards,
Rupasree Achari | BI & Fabric Analytics Engineer

Hi powerbidev123 

Query Folding is the process where Power BI converts your Power Query transformations into a native query (such as SQL) and lets the source database do the work instead of Power BI.

• Power BI connects to the data source.
• You apply transformations in Power Query (filter, remove columns, sort, etc.).
• Power BI checks whether each step can be translated into the source native query language.
• If it can, the database executes those transformations and returns only the required data.
  Note: If a step cannot be translated, query folding stops, and the remaining transformations are performed by Power BI.

You can check whether a step is folding by right-clicking it in Power Query and selecting View Native Query. If it's available, folding is still happening up to that step.

If this answers your questions, kindly accept it as a solution and give kudos