Forum Discussion

tecumseh's avatar
tecumseh
Resolver III
3 years ago

Connect Google Big Query With Date Parameters

Hi all,

 

Using PBI desktop.
I connected to Google Big Query and imported data  - great!

But I need to specify the date range using parameters.

 

I created parameters:
GBQ_Begin_Date = 5/1/2023

GBQ_End_Date = 6/30/2023

How can I edit the connection string to use those parameters?
Here's current connection string:

let
Source = GoogleBigQuery.Database(),
#"path1" = Source{[Name="fakepath1"]}[Data],
Schema = #"path1"{[Name="fakepath2",Kind="Schema"]}[Data],
path2 = Schema{[Name="fakepath3",Kind="Table"]}[Data],
#"Removed Columns" = Table.RemoveColumns(path2,{"x_id", "y_id"})
in
#"Removed Columns"

Thanks,
-w

1 Reply

  • Hey, I'm not too familiar with using parameters myself, but I think you'll need to use the parameters in the SQL statement that you can get by clicking on the gears icon next to Source, which should open a popup where you can edit the connection string to use the parameters: