Feedback by UserVoice

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

Add Get Parameter button to Power Query and avoid Privacy / Formula.Firewall problems

It's fantastic that you can pick up named ranges in Excel and pass them to Power Query as parameters. However the process is cumbersome and often results in Formula.Firewall warnings or other issues.

This leads to having to switch Privacy Levels to "Ignore" or having to write a query within a query rather than nice and clean "parameter" queries.

It would really simplify things if we could quickly create parameter queries (including a drop down to select parameter type) and that these queries would be immune from the Privacy warnings.

217 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Wyn Hopkins shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
    Accepting Votes  ·  AdminExcel Team [MSFT] (Admin, Office.com) responded  · 

    Interesting suggestion, Wyn. Thanks for logging it.

    Others coming in new to this, please help us prioritize this item by providing your votes.

    thanks

    Ashvini Sharma
    Lead Program Manager
    Excel

    4 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • Chris Bennett commented  ·   ·  Flag as inappropriate

        Coming from the old MS Query parameters where you simply selected a cell and could edit the SQL query to add or delete parameters on fields - this new version is really clunky and could be simpler, so I support this simplification request.

      • Sam commented  ·   ·  Flag as inappropriate

        Hi Ashvini - Specifying a range as a method of passing a parameter to a query was there in the good old Database query
        So logically it should have been in Power Query right from the beginning

      Feedback and Knowledge Base