Forum Discussion

DebbieE's avatar
DebbieE
Community Champion
6 years ago

Incremental Refresh Detect Data Changes. How does it know which the the same record

Ive been asked for more information on Incremental refresh

 

Say you store 24 months of  data and you set Detect Data Changes to On. Only refresh data is your LastUpdatedDate has been changed.

 

How does Power BI Understand the row to be the same row?  Basically they want more information on how Power BI understands that the row in Power BI and the new row are the same. I couldnt reaadily find any information on this.

 

 

Need Help

2 Replies

  • v-xicai's avatar
    v-xicai
    Community Support
    6 years ago

    Hi DebbieE ,

     

    The first refresh operation loads historical data. Subsequent refreshes are incremental. You may refer to the document : Incremental refresh in Power BI Premium.

     

    Best Regards,

    Amy

     

    Community Support Team _ Amy

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

    • DebbieE's avatar
      DebbieE
      Community Champion
      6 years ago

      This is the document I read when researching Incremental Refresh but it doesnt seem to answer my question

       

      I understand that If the source Update Date changes then the record is flagged as changed and we can updated it.

      It doesnt however show what in the data sets it as the same record. I cant find any information on this part  of the process?

       

      Please could anyone help me on this?