Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Is there a way to track data changes?

Is there a way in Power BI to track what records have changed between data refreshed? For example, I have a status column in one of my tables. If a record is Open on the first refresh but Closed on the second refresh I would like to know which records changed and what the previous and current statuses are. Is that possible?

Need Help

3 Replies

  • v-lid-msft's avatar
    v-lid-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous ,


    Sorry for that, Based on my research, it is not supported yet currently . We also not found an effective solution to achieve your requirement within Power BI.

     

    Best regards,

    Community Support Team _ Dong Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • OneWithQuestion's avatar
      OneWithQuestion
      Icon for Post Prodigy rankPost Prodigy
      6 years ago

      The system holds two copies of the model right, the current in memory model, and then new model it is processing?

       

      Then after processing finishes IF there are no processing failures it drops the original memory model and replaces it with the newly processed one?

       

       

  • d_gosbell's avatar
    d_gosbell
    Icon for Super User rankSuper User
    6 years ago

    No Power BI effectively does the equivalent of a delete and re-load. So it has no knowledge of the prior state of a given record. Change tracking like this should typically be implemented in a downstream system (like a data warehouse).