Saving the call to API

turbofred69 — Mon, 07 Jun 2021 10:54:13 GMT

Hi all,

I need some information to built a report through an API call.

Calling the API works fine, but I've an additional challenge...

- The value returned by the API is either "unknown" or a date. Once the date is known, it no longer changes ==> So I need only one API call. It is useless to call the API again during later refresh.

- The API doesn't keep history over 2 months. The API reply is then back "unknown" ==> I need to record the date previously provided by the API to keep an history longer than 2 months

Any suggestions about how to do that? I've started to create a new table, but I can't figure out how to update this table with new API replies to keep them over time.

Any help appreciated of course!

Re: Saving the call to API

V-lianl-msft — Wed, 09 Jun 2021 05:52:03 GMT

Hi @turbofred69 ,

You can try to use data flow and incremental refresh to save historical data.

https://visualbi.com/blogs/microsoft/powerbi/historical-data-preservation-using-power-bi-dataflow/

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

topic Saving the call to API in Developer

Saving the call to API

Re: Saving the call to API