How to parameter connexion to Big Query

[Sophie_]

Hello,

i have this connexion :

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

How to put a parameter for #"my_project" ?

[Anonymous]

Hi @Sophie_ 

Did the solution dufoq3 offered help you solve the problem, if it helps you can consider to accept it as a solution so that more user can refer to.

Best Regards!

Yolo Zhu

[dufoq3 · Accepted solution]

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.