Feedback by UserVoice

How can we improve Excel for Windows (Desktop Application)?

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.

13 votes
Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)

We’ll send you updates on this idea

DullRazr shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

3 comments

Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)
Submitting...
  • Paul Andres commented  ·   ·  Flag as inappropriate

    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.

  • DullRazr commented  ·   ·  Flag as inappropriate

    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.

  • DullRazr commented  ·   ·  Flag as inappropriate

    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.

Feedback and Knowledge Base