ODBC Url connection How to put a parameter

[CTouu]

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 want to switch between them. 

In the source of each query I've got this : 

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

I created a parameter with a list of several values : 

1	database1
2	database2
3	database3

But I can't manage to add this parameter instead of my "databasename" which is harcoded. 


Thank you by advance for your help, 

[CTouu]

I put it in the query editor instead of "databasename" I want to add a parameter but it doesn't work

[CTouu]

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]

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

How?

[CTouu]

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]

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?

[CTouu]

I think you didn't understood my issue. 

I just want to know how to variabilize an ODBC Source in the Query Editor 

For example : 

I need to import 23 tables

if I have a DEVELOPMENT database with a dbname A

and a PROD database with a dbname B

I want to know how to switch the dbname without having to change the dbname manually in each of the 23 tables 

[lbendlin · Accepted solution]

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

[CTouu]

yes it works !! Thank you very much for your help ! I missed the & & characters !

[lbendlin]

how do you decide which of the parameter values to use?

Note that whatever you try to do here it will not work in the Power BI service.