Forum Discussion
Incremental refresh for dataflow takes as much time as full refresh
Can you define a view in the you SQL source that defines the query, including the CTEs, that you call in your data flow?
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.
Super Usernot sure what you mean by custom select
this is what i meant:
- Deku
Have you applied the folding flag on the native query like this?
Value.NativeQuery(Source, "SELECT DepartmentID, Name FROM HumanResources.Department WHERE GroupName = 'Research and Development' ", null, [EnableFolding = true])
yes, I did, that's the workaround I found online instead of putting my sql query in the advanced options. I was asking if there is any other way to enable query folding as i can't wrap a sql query containing CTEs in Value.NativeQuery(Source, ...).. it gives me an error