Forum Discussion

Aaj_kundli's avatar
Aaj_kundli
New Member
5 years ago
Solved

Unable to store historical data from api

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@2020_2021&reportdate=2020-10-02

Need Help
  • ibarrau's avatar
    ibarrau
    5 years ago

    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,

1 Reply

  • ibarrau's avatar
    ibarrau
    Icon for Super User rankSuper User
    5 years ago

    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,