Create dynamic Power Query SQL by using Excel table column?

Hi Michael,

You may use parameter in sql-native way if use Value.NativeQuery like

let
    Parameter = [pFilterSN = Filter],
    Source = Sql.Database("MyServer", "MyDatabase"),
    Query = Value.NativeQuery(Source,
  
/* SQL starts-----------*/ "
declare 
@myAnotherParameter bit = 0; --here could be any static parameter(s)

 	 SELECT *  
      FROM MyTable
      WHERE
		 @MyAnotherParameter = 0 AND SN = @pFilterSN
      ORDER BY SN
"  /* SQL ends--*/, Parameter),

    AnotherSort = Table.Sort(Query,{{"SN", Order.Ascending}}),

in
    AnotherSort

or combine query string with your parameter string like

let

    pFilterSN = Filter,
    Source = Sql.Database("MyServer", "MyDatabase",
      [Query="
declare 
@myAnotherParameter bit = 0; --here could be any static parameter(s)
   SELECT *
      FROM MyTable
      WHERE
		 @MyAnotherParameter = 0 AND SN = " & pFilterSN & "
      ORDER BY SN"]),
    AnotherSort = Table.Sort(Source,{{"SN", Order.Ascending}}),
in
    AnotherSort