API Data storage

[trwatts]

Hi Everyone,

Not sure if this is the right spot for this question.
I have an API that I can call the last 7 days' worth of data.
I need to store the data from each refresh and append new data so I can keep historical data.
API's are really new to me and I have no idea how people are storing that data to be used in Power Bi. I can call the data just have no idea how to store it.
I have premium per user if that makes a difference.
Any help would be fantastic.

[Anonymous]

Hi @trwatts,

AFAIK, the current power bi does not include historical data features. I'd like to suggest you extract and store these data to an additional data source and use power bi get data from the transit data source instead of the api.
Regards,

Xiaoxin Sheng

[amitchandak]

@trwatts , Try DAX append method can help

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/