Forum Discussion

Narukkp's avatar
Narukkp
Helper V
6 years ago
Solved

Updated record behavior in data flow incremental refresh

Hi Team,   I have a doubt on Power bi Dataflow incremental refresh, If we enable the incremental refresh on dataflow how it will handle the updated records i.e. if suppose I have one employee and h...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    6 years ago

    Hi Narukkp ,

     

    For the existing record, the refresh process will update it, not delete it and add a new record at the end of the table.

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Narukkp's avatar
Narukkp
Helper V
6 years ago

Hi,
v-lionel-msft  thank you for response but here my ask is internally power bi how it will do  i mean for existing record it will delete and insert the new record or just update the existing record ?

v-lionel-msft's avatar
v-lionel-msft
Community Support
6 years ago

Hi Narukkp ,

 

For the existing record, the refresh process will update it, not delete it and add a new record at the end of the table.

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • vkarumanchi's avatar
    vkarumanchi
    Helper I
    6 years ago

    But for me its appending one more record at the end instead of updating the existing record.

    scenario : I'm using SQL server and set incremental on abc table ( one month History load and 1 week incremental)

                    Updated one record in source before refresh run.

                    one record is appended to dataset after refresh don.

     

    Please make it as solution is it seems to be.

    Thank you,

    Vara