Add an option to have Power Query prompt users for a new parameter value
Update Power Query Parameters with an option to prompt users for a new parameter value (or choose a value from the suggested values list) whenever a query is refreshed.
Thank you for showing passion for Power Query and various improvements!
Could you please share more information? Any examples would be great.
[PM @ Excel]
Agree with other user posted today. I'm just looking to have the same functionality that has long since existed in a Microsoft Query. If you add a ? to your query the parameter box pops up and you can have your end user enter whatever they'd like. Typically I use that to point to a cell as I'll have a query with multiple parameters, they just fill those out and click refresh and the query returns exactly what they want.
Ideally the parameter would actually modify the base query, I don't need to pull down 1.5 million records from my database only to display the 200 records the user ultimately wants. The existing parameters modify the server side query for Sql Server. Though ANYTHING would be better than how it is now. My users are not savvy enough to do this so I'm still using MS Query.
The way parameters work in Power Query, it is not obvious to a typical end user how or where to update the values. What I envision is the equivalent to the way it works with MSQuery and parameters. When you refresh, it pops a window asking you to enter the parameter values. Very slick and sorely missed in Power Query. It really needs to be simpler for the end users. I attached a sample of what a MSQuery prompt looks like when activated.
Please add this to allow the replacement of query editor.
Paul Andres commented
Having a mechanism to utilize externally entered parameters, whether entered in a dialog box or from the same Excel workbook would increase the value of the Power Query functionality.
This is THE MOST requested functionality in my organization. As it stands now, it takes fairly advanced knowledge of Power Query and the M language to create this functionality. Seems like it should be built-in.
Update Power Query Parameters functionality so it can read a parameter value directly from a range on a worksheet. Likewise, add the ability to read a list of suggested values for a Power Query parameter directly from a range on a worksheet.