Power query | parameter query to filter data a predefined list from google bigquery database

Power Query
1

hi,

i get my data for period beginning 01 January 2015 from google bigquery as follows:

Source = Value.NativeQuery(GoogleBigQuery.Database()
{[Name=“abc-stock”]}[Data],
“select * from abc-stock.uk.uk
where (ORIGIN=‘LAX’ or DEST=‘LAX’)”,
null,
[EnableFolding=true])

i’d like to create a parameter query to filter the ORIGIN and DEST from a pre-defined list (eg. JFK, SFO, LAX) when getting the data from google bigquery.

i’d appreciate any help to show me how to parameter query for that.

tks & krgds, -nik

2

@nikahafiz ,

I think you could set it up like this:

image
image3614×1540 208 KB

And then modify your Source step to read:

Source = Value.NativeQuery(GoogleBigQuery.Database()
{[Name=“abc-stock”]}[Data],
“select * from abc-stock.uk.uk
where (ORIGIN= AirportName or DEST= AirportName)",
null,
[EnableFolding=true])

I hope this is helpful.

– Brian

3

many tks, @BrianJ.

let me give another try as i wasn’t successful with that yesterday.

krgds, -nik

1 Like
4

Hi @nikahafiz,

Did the response above from @BrianJ help you solve your query?

If not, can you let us know where you’re stuck and what additional assistance you need?

If it did, please mark the answer as the SOLUTION by clicking the three dots beside Reply and then tick the check box beside SOLUTION

Thank you

5

hi,

i hv also received the solution to an almost similar problem via

tks, -nik