Transformations supported by Query Folding?

[Anonymous]

Hi,

I’m looking for ressources on what Power Query (M) transformations that are supported by Query Folding, due to its importance when having a powerful server and milllions of rows.
However, I haven’t been able to find much information, so I was hoping someone could point me in the right direction?

So far I’ve found that the following should be supported:
Filtering (on rows or columns)
Joins
Aggregates and GROUP BY
Pivot and unpivot
Numeric calculations
Simple transformations, such as UPPER

Source: https://www.mssqltips.com/sqlservertip/3635/query-folding-in-power-query-to-improve-performance/

[v-yulgu-msft · Accepted solution]

Hi @Anonymous,

Based on my research, I didn't find any document listing all available transformations supported by Query Folding. From this blog, we can know that selecting a tranform in the Query Editor that doesn’t exist in source data might not support Query Folding. 

Best regards,

Yuliana Gu