Forum Discussion

CTouu's avatar
CTouu
Frequent Visitor
3 years ago
Solved

ODBC Url connection How to put a parameter

Hi !    I've got a simple (I think) issue.  I have a simple connection to a Postgre DB Connection by ODBC (i don't use the postgre connector, don't need to propose).  I have several DBs and I wan...
Need Help
  • lbendlin's avatar
    lbendlin
    3 years ago
    = Odbc.DataSource("Driver={PostgreSQL Unicode(x64)};Server=localhost;Port=5432;Database=" & databasename & ";", [HierarchicalNavigation=true])
CTouu's avatar
CTouu
Frequent Visitor
3 years ago

I'm in Power Query in the Desktop. 

I decide which of the parameter value to use in the query editor 

I want to add the parameter name after "database"

= Odbc.DataSource("Driver={PostgreSQL Unicode(x64)};Server=localhost;Port=5432;Database=databasename;", [HierarchicalNavigation=true]) 

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago
    I decide which of the parameter value to use in the query editor

    How?

    • CTouu's avatar
      CTouu
      Frequent Visitor
      3 years ago

      In the Source Query : 

      = Odbc.DataSource("Driver={PostgreSQL Unicode(x64)};Server=localhost;Port=5432;Database=databasename;", [HierarchicalNavigation=true]) 

       

      I want to add a parameter name instead of "databasename" because for now it's hardcoded and I want the database name to be dynamic.

      • lbendlin's avatar
        lbendlin
        Super User
        3 years ago

        Why does it have to be a multi choice parameter? Could it be a scalar parameter instead?

         

        Are you trying to implement your own version of deployment pipelines?