How can i preserve old data in powerbi ?

[Anonymous]

I'm using web api to import data into powerbi. After every refresh, old data is replaced by new data of web api so my question is how can I store that old data in power bi ?

[TomMartens]

Hey @Anonymous ,

if I understand you correctly, the web api exposes only current data, for this reason, data inside Power BI will be overwritten every time a refresh happens.

This article by Chris Webb explains how you can leverage the incremental refresh feature (that is now available in PRO) to refresh your model without purging existing data: https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-data-to-it-using-incremental-refresh/

Hopefully, this is what you are looking for.

Regards,

Tom

[amitchandak]

@Anonymous , refer if this can help

https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/

[Anonymous]

Hi @Anonymous 

I suppose you could make a copy of the report using another name. How often does your data refresh?

[Anonymous]

Once in a day. I only needed let's say some specific number from that wep api to show a graph for last seven days. I only want to store that number.Currently after every refresh I'm not able to keep that data