Forum Discussion

CrazyHorse66's avatar
CrazyHorse66
Helper I
4 years ago
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...
Dataflow
  • lbendlin's avatar
    lbendlin
    4 years ago

    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?

lbendlin's avatar
lbendlin
Super User
4 years ago

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?

  • CrazyHorse66's avatar
    CrazyHorse66
    Helper I
    4 years ago

    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?

     

     

    • lbendlin's avatar
      lbendlin
      Super User
      4 years ago

      Please post the last line of the power query.

      • CrazyHorse66's avatar
        CrazyHorse66
        Helper I
        4 years ago
        #"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"