Add data source parameter to a live data connection.

ArunK what it is pointing to? It is not clear. is it pointing to a semantic model on pre-prod or some backend pre-prod data source? Provide more clarity, please.

Hi ArunK 

Please try this:

First of all, open the Data source settings in the Home pane to see the current data source.

Then select Data source in current file, and select your snowflake preprod and click Change Source to change it to snowflake prod.

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

ArunK I would recommend adding a parameter for the connection string and once it is published to the service you can easily switch between production and non-production environment. This is the way to go if you want to have a scalable solution.

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.