Feedback by UserVoice

Anonymous

My feedback

  1. 339 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Hi all,

    Thank you for taking your time to suggest and vote for adding Get Parameter button to Power Query. We do think that this suggestion has merit but we don’t think that we’ll be able to devote time to it in the near future. We’ll continue tracking votes for it.

    Thanks,
    Guy Hunkin
    Excel Program Manager

    An error occurred while saving the comment
    Anonymous commented  · 

    I used VBA To avoid the formula firewall warning when trying to combine the cell range parameter with the rest of the query as discussed in the original post. Also subsequently found it mentioned here:-

    https://social.technet.microsoft.com/Forums/lync/en-US/8b3a4310-ed6f-4cef-b7d4-8120e5adf8e6/formula-firewall

    Amending Privacy levels not really an option, and query within a query method not appropriate. However amending VBA from this site to build the query using the cell range worked OK.

    https://gallery.technet.microsoft.com/office/VBA-to-automate-Power-956a52d1

    An error occurred while saving the comment
    Anonymous commented  · 

    I've resorted to writing some VBA code to set the M language query in order do what should be a simple thing - grab a value from a text box and use it as a parameter for a web query. Kind of defeats the purpose of using the Get and Transform in the first place....

    Anonymous supported this idea  · 

Feedback and Knowledge Base