Forum Discussion
Solved
Dataflows incremental refresh
Hi All I have been looking at this for far too long now, any help gratefully received. 1. Created a simple dataflow in a Premium Workspace - connect to SQL DWH and pull all data (it's a very sma...
3. did you mean to say "refreshed the dataflow" ?
How many times did you refresh the dataflow? Incremental refresh only kicks in at the second refresh.
How many partitions are reported in the refresh history log file?
Hi and thanks
Yes I meant it successfully refreshes but the data does not get filtered
I've tried multiple refresh and the data stays the same, RangeStart & RangeEnd do not have the dates I have selected for Incremental Refresh
It looks like there are 7 partitions but none are being processed?
Please post the last line of the power query.
- #"Fact_ChatTransfer-4372656174656444617465-autogenerated_for_incremental_refresh" = Table.SelectRows(Source, each DateTime.From([CreatedDate]) >= RangeStart and DateTime.From([CreatedDate]) < RangeEnd)in#"Fact_ChatTransfer-4372656174656444617465-autogenerated_for_incremental_refresh"