Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
Solved! Go to Solution.
Some of the most common transformation that support query folding are:
The transformations that do not support query folding include:
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
@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:
The transformations that do not support query folding include:
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
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
Check out the July 2025 Power BI update to learn about new features.