Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Is my feeling correct that all transformations are allowed to a DQ as long as Query folding takes place? Is this the way to find the limits of what can be done?
Solved! Go to Solution.
sorry, correct link https://docs.microsoft.com/en-us/power-query/power-query-folding
sorry, correct link https://docs.microsoft.com/en-us/power-query/power-query-folding
I guess this is the answer in your link that confirms:
DirectQuery and Dual storage mode tables: Each DirectQuery and Dual storage mode table (Power BI only) must be based on a Power Query query that can be folded.
But there are some limitations in the second link 🙂
Transformations that prevent folding
Generally, the following list describes transformations that prevent query folding. This is not intended to be an exhaustive list.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.