Change Date in URL in Power Querry Web API and keep Data

[Anonymous]

Hey guys,

i have an Web API, which looks like this: https://hello123.testsite.net/Api/MessageCenter?action=date&value=2022-02-14.

The API only is able to load a few rows at once.

My idea is to change the date, to load all data. For the future, the date in die URL will be dynamic to the day. 

My question is: How do i keep the loaded, historical data/ rows in Power BI, when the date in the URL is changed manually or automatically to the current date. 

Thank you 😉

[Anonymous]

Thank you!

[mahoneypat · Accepted solution]

You could use the technique described in this article to do that. it is a little advanced, but it should work.

Incrementally load from SAP, APIs or almost anything | Esbrina (esbrina-ba.com)

Pat