I am trying to change the connection string from Dev to UAT using parameters. We are able to change in power BI desktop, need to refresh and upload.
I am aware that paramter option is available in Power BI service, however I am not able to change the value. It is disabled for editing, is it because in the tenant settings configuration is done to disable it? For me it is not enable to change the server IP (that I am using as parameter to flip from dev to UAT)
Folloeing the below blog
Solved! Go to Solution.
I have parameters with default value. And when i load my pbix file, it takes the default value and loads the data.
How to make the user to enter paramter when opened?
still in power bi online, i cannot change the parameter, its not editable. I have added as dropdown for paramters, still not able to change.
Power BI parameters from Guy in a Cube.
This was posted yesterday.
I was able to do this before, however i am getting below issue now when I change the paramter.
I am using server ip as parameter and trying to change the UAT IP to production one. Data source with prod ip is already added as data source in gateway.
Sometimew what happened is that the gateway selection itself is removed from the dataset.
Here is a blog describing how to change data source connection string in Power BI service:
@shamsuddeenvp, take a look at setting up the parameter in the client and then you will be able to achieve hopefully what you were wanting to do between changing environments.
See the answer for this post. The 2nd reference if what you want to achieve.
2nd Reference from link above:
Hope this helps!
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.