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.
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.