Forum Discussion
How to parameter connexion to Big Query
- 1 year ago
Hi Sophie_, #"my_project" is only step name. You should focus on this part:
let
Source = GoogleBigQuery.Database(),
#"my_project" = Source{[Name="my_project"]}[Data],
Schema = #"my_project"{[Name="my_dataset",Kind="Schema"]}[Data],
my_dataset.kpi_Table = Schema{[Name="_kpi",Kind="Table"]}[Data]
in
my_dataset.kpi_Tablewich you can replace with your parameter without quotes:
#"my_project" = Source{[Name=myParameter]}[Data],
If you need additional assistance - be more specific please. What kind of parameter do you have/need. How exactly do you want to use such parameter. Add at least some screenshots data where you want to use it etc.
Hi Sophie_, #"my_project" is only step name. You should focus on this part:
let
Source = GoogleBigQuery.Database(),
#"my_project" = Source{[Name="my_project"]}[Data],
Schema = #"my_project"{[Name="my_dataset",Kind="Schema"]}[Data],
my_dataset.kpi_Table = Schema{[Name="_kpi",Kind="Table"]}[Data]
in
my_dataset.kpi_Table
wich you can replace with your parameter without quotes:
#"my_project" = Source{[Name=myParameter]}[Data],
If you need additional assistance - be more specific please. What kind of parameter do you have/need. How exactly do you want to use such parameter. Add at least some screenshots data where you want to use it etc.