power query | dynamic selection/filtering using directquery to bring in data

[hood2media]

hi,
currently  i manage to import data from google bigquery using following power query script

let
Source = Value.NativeQuery(GoogleBigQuery.Database(){[Name="h2m-aviation"]}[Data], "select * from aviation.us.airports where (ORIGIN='JFK' or DEST='JFK')", null, [EnableFolding=true]),
#"Sorted Rows" = Table.Sort(Source,{{"FL_DATE", Order.Descending}})
in
#"Sorted Rows"

however, as can be seen above, the selection/filtering of ORIGIN & DEST is hard-coded. kindly advise on how to make dynamic selection/filtering such that i can choose other values from a list that i can create separately (e.g. airport_list with choices for JFK, LAX, SFO) that brings back data from google bigquery based on the selected value (for ORIGIN or DEST(ination) airport).

thanks & kind regards,

-nik

[hood2media]

many thanks, @amitchandak.

i thot i cud find a power query / m-lang solution to this as m not so familiar wth sql at this moment. 

nonetheless, i'll check accordingly.

krgds, -nik

[amitchandak · Accepted solution]

@hood2media , Check if Dynamic M Parameters can help

https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters