cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Post Patron
Post Patron

Parameter is disabled for editing in power bi service

Dear,

 

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

 

https://www.fourmoo.com/2018/03/27/using-the-power-bi-service-parameters-to-change-connection-string...

 

Br,

Shams

1 ACCEPTED SOLUTION

Accepted Solutions

Hi there,

Make sure that your parameter data type is NOT set to ANY, it must be set to Text or Decimal.

Make the change above and re-upload the file.




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

8 REPLIES 8
Responsive Resident
Responsive Resident

@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.

https://community.powerbi.com/t5/Desktop/datasource-change-with-parameters/td-p/85128

 

2nd Reference from link above:

http://biinsight.com/power-bi-desktop-query-parameters-part-1/

 

Hope this helps!

Microsoft
Microsoft

Hi @shamsuddeenvp,

 

Here is a blog describing how to change data source connection string in Power BI service:

Using the Power BI Service Parameters to change connection strings (To possibly change between Dev,

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super User III
Super User III

Hi there, when you connected to your data source, did you connect to it using the parameter?




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Thanks @GilbertQ

 

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.

 

Br,

Shams

Hi there,

Make sure that your parameter data type is NOT set to ANY, it must be set to Text or Decimal.

Make the change above and re-upload the file.




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

Thanks @GilbertQ

 

It works. 🙂

 

Power BI parameters from Guy in a Cube.

 

https://guyinacube.com/2018/04/power-bi-parameters-updating-power-bi-service-apis/

 

This was posted yesterday.

Dear,

 

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.

 

ParamterChangeIssue.png

 

Br,

Shams

Helpful resources

Announcements
November Update

Check it Out!

Click here to read more about the November 2020 Updates!

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform October Community Highlights

Check out the top community contributors across all of the communities

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors