What transformations are allowed in Direct Query?

[richard-powerbi]

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?

[az38 · Accepted solution]

@richard-powerbi 

sorry, correct link https://docs.microsoft.com/en-us/power-query/power-query-folding

[richard-powerbi]

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.

[az38]

@richard-powerbi 

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.

[az38]

Hi @richard-powerbi 

not sure https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery#limitations-of-direct...