Forum Discussion

hood2media's avatar
hood2media
Resolver II
3 years ago
Solved

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

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