Incremental copy

[mazzasette]

I have the following problem: The source table changes the data every day and deletes them so I would like to copy them incrementally to another table so that I can have the history. It's possible?

Thanks

[amitchandak · Accepted solution]

@mazzasette , There is approch DAX append. to add add in the same table

https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-...
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/

[v-shex-msft · Accepted solution]

Hi @mazzasette,

Unfortalblely, power bi desktop doesn't include in the cache history data feature. These old version data will be updated/replaced if your source data changes.

Perhaps you try to use integrate R or Python scripts to backup operation to export these history data to local device and name with system DateTime.

Regards,

Xiaoxin Sheng

[amitchandak · Accepted solution]

@mazzasette , There is approch DAX append. to add add in the same table

https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-...
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/

[mazzasette]

Thanks for the fast answer, I try it.