Forum Discussion
Transformations supported by Query Folding?
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/
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/
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
1 Reply
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