Persisting data while using API as a data source

[Numer8]

Hello Gurus,

I am trying to connect to a API for ingesting data onto PowerBI.

The connection behaves correctly using the web connector. However, I have a problem with persisting the data between refresh.

So my API refreshes every 60 seconds and returns last 1 minute data.

Upon successful connection, I am being able to see last 1 minute data populated in the table.

But, next minute when the API refreshes, the data is entirely replaced and no appended.

Is there a way to persist the old data while with every API refresh, the new set of rows will add to the data .

Is there a way of doing the above directly on Power BI

Kindly Help.

Thank you very much for your time.

Regards,

Dev

[v-juanli-msft · Accepted solution]

Hi @Numer8 

I'm afraid it is impossible to store historical data when refresh.

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Numer8]

Alright. I will have to setup a storage space then . 

Thank you