Forum Discussion
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
hood2media , Check if Dynamic M Parameters can help
https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters
2 Replies
- amitchandakSuper User
hood2media , Check if Dynamic M Parameters can help
https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters
- hood2mediaResolver II
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