The way to extend all the data instead of updates

[jlegutko_abb]

Hi,

Is there any automatic way in Power BI Desktop or Service (something in seetings of refreshment) to keep existing data and only add the new data instead of update them (extend the data)? Everything is from one data source (in my case it is Sharepoint list which is updated almost every day and I want to save all the statuses and dates of modyfing, not update them).

Thank you!

[amitchandak · Accepted solution]

@jlegutko_abb , check this DAX append technique

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/