Forum Discussion
Solved
Incremental refresh for dataflow takes as much time as full refresh
Hello, I've used incremental refresh for my dataflow, but it takes almost as long as the full refresh. He're below is the configuration and the timings: for the full refresh (~15min): ...
Can you define a view in the you SQL source that defines the query, including the CTEs, that you call in your data flow?
How do I know if the query is folding ? here's what I see in the dataflow editor:
Deku
Super User
Super UserThe red green colour strip indicates query folding
https://learn.microsoft.com/en-us/power-query/step-folding-indicators
You can see your second step breaks folding as it has a red indicator
thank you, I believe it's because i'm using a custom select. I searched online and the only thing I found to enable query folding with custom select is to add a step with Value.NativeQuery(...) and put the sql query inside
is there any other way to enable query folding apart from this workaround ? this workaround doesn't seem to allow the use of ctes.