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.
Interesting suggestion, Wyn. Thanks for logging it.
Others coming in new to this, please help us prioritize this item by providing your votes.
Lead Program Manager
Chris Bennett commented
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.
Ivan Bondarenko commented
Agree with idea. Frequently face the same issue.
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
What happened to 'find'?