opening multiple api links in power bi

[hussein_c]

I have multiple API links from sensibo which only change their ID. for example: "https://home.sensibo.com/api/v2/pods/ID1/measurements" and "https://home.sensibo.com/api/v2/pods/ID2/measurements"... i want to be able to open all these links in power bi without having "get data --> from web" for each link. i saw that i can creat a list of api urls and use a function to access those apis and iterate over the list, but i don't know how to start.

thank you in advance for the help

[lbendlin · Accepted solution]

The technical approach is to use the RelativePath attribute.

BUT:  If you do that you will enforce a sequential call to the API which can have a dramatic impact on performance.  Sometimes having separate queries makes more sense.