Aug 20 2019 10:24 AM
How do I force the query to prompt for a parameter value to use to filter result?
Aug 20 2019 10:57 AM
SolutionYou can't prompt parameter to take it from input window field, but you could use some cell value in your sheet as parameter passing it to query. See, for example, https://www.excelguru.ca/blog/2018/05/30/creating-dynamic-parameters-in-power-query/
Aug 21 2019 08:28 AM
Thanks for pointing me in the right direction to solve issue! @Sergei Baklan
Aug 20 2019 10:57 AM
SolutionYou can't prompt parameter to take it from input window field, but you could use some cell value in your sheet as parameter passing it to query. See, for example, https://www.excelguru.ca/blog/2018/05/30/creating-dynamic-parameters-in-power-query/