Forum Discussion
Masahiro Yaguchi
Nov 29, 2017Copper Contributor
[Power Query] How to use parameter.
Hello all,
I would like to run query to SQL Server's table with parameter.
I want to use the value of any cell in the spreadsheet as a condition of SQL.
Please let me know the procedure.
Thanks.
Hi Masahiro,
Please check this thread https://techcommunity.microsoft.com/t5/Get-and-Transform-Data/How-do-you-do-a-parameter-query-when-not-using-Microsoft-Query/m-p/94026#M214, idea is the same.
- Masahiro YaguchiCopper Contributor
Hello Sergei,
Thank you for your reply. I would like to confirm your link page.
Thank you!