Load in multiple API requests as one data source

[Anonymous]

Hello everyone,

I'm trying to request multiple data tables from the same API adress, but each request has a different parameter (rest stays the same).

This is because the API only allows me to fetch data for 1 year MAX. I want to load in multiple years at the same time in the same table (table layout is the same). See how it is fetched now for 1 year:

The untilDate and fromDate are the ones I would like to retrieve multiple times so for example

untilDate = 2021-12-31&fromDate=2021-01-01  && untilDate = 2022-12-31&fromDate=2022-01-01.

Is there someone that can help me with this one, like with PowerQuery M or something?

Thanks in advance! 

[amitchandak]

@Anonymous , refer if this can help

https://blog.crossjoin.co.uk/2016/08/16/using-the-relativepath-and-query-options-with-web-contents-in-power-query-and-power-bi-m-code/