Forum Discussion
Can we use Query Folding in Direct Query mode.
Hi Folks,
I have Direct query mode for my SQL Server. In Direct Query Table view is Disable then How can i use Query Folding in DQ Mode.
Can you please help me in this.
Some of the most common transformation that support query folding are:
- Removing or renaming columns
- Merging foldable queries that are based on the same source.
- Appending foldable queries based on the same source.
- Numeric calculations
- Joins
- Pivot and unpivot
The transformations that do not support query folding include:
- Merging or appending queries that are based on different sources.
- Using some functions while adding custom columns that do not have a counterpart in SQL.
- Adding columns with complex logic. These refer to functions that do not have equivalent functions in the data source.
The rule of thumb that I use : is or possible to do this opération in SQL ? If yes then low chance to break m'y query folding
3 Replies
For a DirectQuery or Dual storage mode table, the Power Query query must achieve query folding, this is why some transformations are not supported by DQ
So by default, it is used 🙂
You can find more details under the following url:
https://learn.microsoft.com/en-us/power-bi/guidance/power-query-folding
Cookistador Thank you for reply.
Power Query also use some transformations for Query Folding right then how it differ
Some of the most common transformation that support query folding are:
- Removing or renaming columns
- Merging foldable queries that are based on the same source.
- Appending foldable queries based on the same source.
- Numeric calculations
- Joins
- Pivot and unpivot
The transformations that do not support query folding include:
- Merging or appending queries that are based on different sources.
- Using some functions while adding custom columns that do not have a counterpart in SQL.
- Adding columns with complex logic. These refer to functions that do not have equivalent functions in the data source.
The rule of thumb that I use : is or possible to do this opération in SQL ? If yes then low chance to break m'y query folding
