Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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,
Solved! Go to Solution.
= Odbc.DataSource("Driver={PostgreSQL Unicode(x64)};Server=localhost;Port=5432;Database=" & databasename & ";", [HierarchicalNavigation=true])
I put it in the query editor instead of "databasename" I want to add a parameter but it doesn't work
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])
I decide which of the parameter value to use in the query editor
How?
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.
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?
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
= Odbc.DataSource("Driver={PostgreSQL Unicode(x64)};Server=localhost;Port=5432;Database=" & databasename & ";", [HierarchicalNavigation=true])
yes it works !! Thank you very much for your help ! I missed the & & characters !
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.
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
41 | |
27 | |
27 | |
20 | |
13 |
User | Count |
---|---|
68 | |
55 | |
42 | |
28 | |
22 |