Forum Discussion
Solved
What transformations are allowed in Direct Query?
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?
sorry, correct link https://docs.microsoft.com/en-us/power-query/power-query-folding
4 Replies
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.
