2019 Power Query

[127bit]

I am currently executing multiple queries that pull the same kind of data from one source, ie:

https://www.website.com/page/value1

https://www.website.com/page/value2

etc.

Is there a way to pass a variable (value1) to one query, execute it, then pass the next variable (value2) to it and execute again? I'm wondering if it would be more efficient than executing numerous queries to the same site with just the last value changing.
Thanks.

 

[alansidman]

If you are looking to have all the pages combined into one query, then run multiple queries and then combine (append) then to each other. Is this what you want to do or am I missing something in your explanation.

 

[127bit]

Hello Alan, thanks for picking this up.
Specifically, this workbook has dozens of queries that grab stock prices and other data from the same site, and presents them as a portfolio-tracking table. Since they are the same querying the same data source with just the ticker changed each time, I wondered if this has grown to become inefficient. Should it instead make one connection to the page and keep re-using it with a new variable (ticker) each time? If yes, how?
Thanks.

 

[alansidman]

Yes. Build a parameter query in Power Query. Here is an example from MrE on how to build a parameter query.