Unable to store historical data from api

[Aaj_kundli]

My api gives me the current date data every time for new date and I want to store the historical data and to add the new current date data.

But while refreshing the data gets overwritten and the past data gets lost.

Please share any solution.

WEB API:

http://wmsapi.aajenterprises.com/WMSReport.svc/Json/CartonListwithdate?wcode=1&databasename=eswms@20...

[ibarrau · Accepted solution]

Hi. The problem is that Power Bi is a tool for reading data. If you need to storage data from an api I suggest looking at azure services in order to build a process that takes data and storage it. You can use DataFactory or Azure Functions to read the api and then insert it in a lake gen2 or a database. That way you will save your own historical data that will be consumed by Power Bi later.

Regards,