Power BI: How to Combine Multiple Excel Files from Multiple Websites

Select your query and open Advanced Editor and then add a line in at the top like

( urlToGet as text ) =>

and that should turn the query into a function. You will need to replace the existing URL in your query with urlToGet.

Create a new query to get your list of URLs, from a text file or wherever. Add a step to that new query using the Invoke Custom Function button on the Add Column ribbon, and choose the function that you created. Expand the new table column and it should pull in all the data.