Saving Historical Data from own Rest API to Power BI Desktop.

[walid140891]

Hello,

We are totally new to power bi (pro accounts) and we are drawing dashboards and reports in power BI Desktop with data coming from our Rest API, the problem is that we have data related to several years for each customer, Do we have a way to save the data in power bi before cleaning our application data. That means we want the client data somehow to be saved in power bi and refreshed only when we have new or updated data.

We made our researches on the internet but it's not very clear for us.

Thank you in advance.

[Syndicate_Admin]

Could you find a solution to this? Thanks a lot!

[amitchandak · Accepted solution]

@walid140891 , Not very clear. But seem like das append can help.

check these blog

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/

[walid140891]

@amitchandak 
Thank you for your response, I'll try to clarify:

We are getting data from our web application through web API or jsons, and we want, even if data is deleted from our account, to keep it in power bi.
That means we want to keep historical data in power bi to be calculated and included in the current analysis.