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?
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
- Deku
Can you define a view in the you SQL source that defines the query, including the CTEs, that you call in your data flow?