Forum Discussion
Snowflake update datasource API
That's weird but it look like you have an error in your code that make the request. if you want to make it easier for the text in the parameter try entering data in a new table with two columns. One of them is going to be the name of the environment and the second column the server name. If you need a third one for db name you can also create it. Then create a parameter that will filter the table with environment name.
Now for regular tables just take the first row in the entered data table to complete de server.
That way you can add new environments or change them dynamically in a more secure way.
I hope that make sense
Super UserHi. I usually recommend using parameters to change the data source. Just like the examples on youtube that they use to change it manually, but using the API
https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/update-parameters-in-group
The issue updating the sources directly is that every sources has different structure for the body. That can make the request quite difficult.
If you build on your reports a hidden dummy table with prod and dev environment that will filter by a parameter you can even use the same code/script for every report. You can take it to the next level.
I hope that helps,
You are not able to update the data source.
When you use parameters to configure the connection. You are not able to update the paramaters through API calls. The data source is snowflake.
Parameters:
Even in the Power Bi portal, the parameters cannot be edited, the fields are disabled.
- ibarrau
That's weird but it look like you have an error in your code that make the request. if you want to make it easier for the text in the parameter try entering data in a new table with two columns. One of them is going to be the name of the environment and the second column the server name. If you need a third one for db name you can also create it. Then create a parameter that will filter the table with environment name.
Now for regular tables just take the first row in the entered data table to complete de server.
That way you can add new environments or change them dynamically in a more secure way.
I hope that make sense