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

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 😉