Forum Discussion

iBusinessBI's avatar
iBusinessBI
Kudo Collector
4 years ago
Solved

Incremental refresh with additional steps after RangeStart RangeEnd filtering

I want to incrementally refresh my table, which uses two data sources:
- SQL Server. 

- the second source is coming from the Dataflow

In my query I use Value.NativeQuery with [EnableFolding = true] as the first step 

Then I filter using RangeStart and RangeEnd parameters.

But then I Append a table from another dataflow query, which of course breaks the query folding.

I've cheked and all the steps before "Appended Query" are folded.

How does the Incremental refresh behave in this scenario?

Will the filtering for the partitions fold to the SQL Server?

In which partition will it Append the table from the dataflow?

 

 

  • In a dataflow the range filtering is always (annoyingly) forced to be the last transform.  In a dataset you can place the filter anywhere you want.

1 Reply

  • In a dataflow the range filtering is always (annoyingly) forced to be the last transform.  In a dataset you can place the filter anywhere you want.