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?
this is what i meant:
Super UserHave 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?
not a bad idea, i will do this then, thank you ! 🙂