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.

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

Hi Narukkp ,

 

The refresh mechanism in Power BI just returns the fact data of the data source or the query results to the dataset in the .pbix file. Whether the data is updated or inserted depends on the data table of the data source.

The refresh strategy is just a mover between the data source and the dataset. This process of moving data is similar to the copy + overlay method.

 

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