PowerQuery Invoke Variables on Refresh

[betsig250]

Hello. Learning how to write some stuff in PowerQuery today. I created some variables for a web query through the Advance Editor. I know once I write it I have to click the Invoke Button and type in values I want.

Now how do I send this out and have users change these variables without having to go inside PowerQuery and going to the Advance Editor and re-invoking them? In a perfect world, when they click refresh on the Query ribbon I would like the Invoke screen to come up and they can type in the new variables.

Is this possible?

 

[theBardd]

You need to create an Excel table where the user inputs the values, and pull these into your query. I wrote a blog post on this topic last month, Excel is for Parameters