Odata queries dynamic URL in one database

[Markusm]

Hi

I want to fetch Sharepoint User lists and security groups by using the Rest API.
The URL to the odata feed is:

http://siteURL.com/_api/Web/SiteGroups/GetById(1)

The ID (red) is dynamic. There are different IDs for each security group. I got all IDs in another odata query.

For now I managed to set a dynamic URL connection like stated here: https://community.powerbi.com/t5/Desktop/How-to-setting-a-dynamic-URL-connection/td-p/57072

So I am able to Change the standard-value at the parameter and the Odata query (Abfrage3) changes automatically.
( eg. http://siteurl.com/_api/Web/SiteGroups/GetById(8) )

My goal is to fetch all this Odata queries into one database.
There are more than 250 IDs.... Is that possible?

Thank you in advance!
PS: My Power Query skills are at a beginner-level... but I am learning every day

Thanks
Markus

 

[Bob Phillips]

It would seem to me that you could put all 250 URLs into a table, open that in PQ, then have a function (similar to what you have for the dynamic URL) that you assign into a separate column, then unpack the results. Can't be more explicit as I don't know your code nor the URLs.