Forum Discussion

Sophie_'s avatar
Sophie_
Frequent Visitor
1 year ago
Solved

How to parameter connexion to Big Query

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], ...
  • dufoq3's avatar
    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_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.