Persisting data while using API as a data source

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