[Power Query] How to use parameter.

[Masahiro Yaguchi]

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.

[#2]

Hi Masahiro,

Please check this thread https://techcommunity.microsoft.com/t5/Get-and-Transform-Data/How-do-you-do-a-parameter-query-when-n..., idea is the same.

[#3]

Hello Sergei,

Thank you for your reply. I would like to confirm your link page.

Thank you!