Forum Discussion
Add data source parameter to a live data connection.
Hi, I have a fully fledged pbi report with multiple pages and measures.This report is pointing to snowflake preprod and I want to change the datasource to snowflake prod.(There is no semantic mo...
ArunK You have to add a parameter in PQ and replace the live connection string with the parameter.
Let's assume, you have a IP address and database name for the connection (I don't use Snowflake so not sure what included in the parameter).
Given above example, I will create 2 parameter, one for IP and other for db name, and in the table where fixed value of the IP and db name is given, replace that with the parameter value.
Now as you change the parameter value it will change the connection string for the table and everything should work.
Power Query editor is not available in live connection which is preventing the parameter creation.