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

Can you confirm that your sample's [Created Date]  values fall into the buckets defined by the partitions?

  • CrazyHorse66's avatar
    CrazyHorse66
    Helper I
    4 years ago

    Hi, here's the 'raw' data, dates in September 2021

    And here's what I set for incremental to test, but nothing changes

    Strange though it has the values twice in dropdown to filter - Created Date

     

    • lbendlin's avatar
      lbendlin
      Super User
      4 years ago

      That would be your answer.  Your source data is ambiguous with two columns having the same name, and the Power BI service got confused and chose the wrong one.

      • CrazyHorse66's avatar
        CrazyHorse66
        Helper I
        4 years ago

        Thanks, but the source data does not have columns with same name, for some reason the dropdown to select from does however?