Loop API call to obtain results based on single param change (from a list)

Hi, DamianMcc ;

When you add a custom column (Invoke Custom Function), change the drop down to Column Name and select the app_id column.  Then, the function will pass in the app_id value from each row into the function (into the URL) and perform the query steps you designed earlier.  If you need to pass a bearer token to the URL for each app_id value, if it is the same bearer token for every app_id, you can add an Authorization header to the URL request.

Loop through list a to perform a REST API call and... - Microsoft Power BI Community

How to loop through an API with Power BI without knowing last page – PBI Guy (pbi-guy.com)

Use Power BI to loop through multiple pages of an API - YouTube

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.