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?
Deku
Super User
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