cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Microsoft repaaksp
Microsoft

datasource change with parameters

Hi,

 

 

how to select automatically the web datasource if one server is down and the other server is up. I have declared parameters with both servers and in the data load view one part of the url is the parameter. default value and current value are the same. But the only way to change the server is to do that in the parameter level. Is there a way to make powerbi to select it automatically (by choosing which server is up )?

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-caliao-msft
Moderator

Re: datasource change with parameters

Hi @repaaksp,

 

Based on your description, you need to set a dynamic parameter value to your parameter.

 

Currently, the available values for a parameter can only from a hardcode list, and parameter value can only be changed manually. For the feature to get parameter available values from a query, I would recommend you submit a feature request in the idea forum: https://ideas.powerbi.com/forums/265200-power-bi-ideas.

 

Reference
https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/
http://biinsight.com/power-bi-desktop-query-parameters-part-1/

 

Regards,

Charlie Liao

View solution in original post

4 REPLIES 4
ankitpatira Super Contributor
Super Contributor

Re: datasource change with parameters

@repaaksp You can change parameter values in pbi desktop by exiting out of query editor (Close&Apply) and then under Home tab -> Edit Queries dropdown -> Edit Parameters.

 

Capture.PNG

Microsoft repaaksp
Microsoft

Re: datasource change with parameters

Yes I know I can edit those myself. But the question is how to make online services choose the parameter itself, depending on which parameter is available

Moderator v-caliao-msft
Moderator

Re: datasource change with parameters

Hi @repaaksp,

 

Based on your description, you need to set a dynamic parameter value to your parameter.

 

Currently, the available values for a parameter can only from a hardcode list, and parameter value can only be changed manually. For the feature to get parameter available values from a query, I would recommend you submit a feature request in the idea forum: https://ideas.powerbi.com/forums/265200-power-bi-ideas.

 

Reference
https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/
http://biinsight.com/power-bi-desktop-query-parameters-part-1/

 

Regards,

Charlie Liao

View solution in original post

barb2ko2 Visitor
Visitor

Re: datasource change with parameters

I'm not seeing a solution to your question as I too am having the same issue with the end user being able to change a date parameter once it is published.

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors