Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

edit parameter / slicer

Hello,   I did a dashboard to see the server Status, Jobs that have succeeded or failed and so on. This dashboard is very popular.   My client asked me to do the same dashboard but for two other...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    Hi Anonymous 

    Edit parameter in Power BI Service is available for users who have edit permission to the dataset,it needs you to go to dataset setting and change the parameter.

    Please see more details here:

    https://docs.microsoft.com/en-us/power-bi/service-parameters

    there are some limitation for editing parameter in power bi service, 

    it should be not parameters that restrict the available data, but parameters that define and describe acceptable values.

    also, it may only work for import mode.

     

    Another way, if 'Servers list and the Data base list" are from two different data source, could you import them together in the data model in power bi desktop, then it would be possible to use the different selection in a slicer.

     

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

v-juanli-msft's avatar
v-juanli-msft
Community Support
6 years ago

Hi Anonymous 

Edit parameter in Power BI Service is available for users who have edit permission to the dataset,it needs you to go to dataset setting and change the parameter.

Please see more details here:

https://docs.microsoft.com/en-us/power-bi/service-parameters

there are some limitation for editing parameter in power bi service, 

it should be not parameters that restrict the available data, but parameters that define and describe acceptable values.

also, it may only work for import mode.

 

Another way, if 'Servers list and the Data base list" are from two different data source, could you import them together in the data model in power bi desktop, then it would be possible to use the different selection in a slicer.

 

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hello Maggie,

     

    When edit parameters, I have to select the server Name and the Database Name then I click on ok.

    Then I need to click on Apply Changes and the information is updated, at least in Power BI Desktop.

     

    For some reasons, I don't know, I am able to use the edit parameters in Power BI Services but the data does not seem to refresh. 

    Also, In Power BI services, when you go to dataset, then in parameters, there is no dropdown list.  The End-user need to provide the Server Name. It is not friendly user.

     

    For those reasons, I might be interested by your second option.

     

    So, imagine that I have two servers and two database ex: Server A and EDW, Server B and EDW_2, could you provide me the steps to add those two data sources in Power BI and especially how can I use a slicer to switch between the two data sources to have the data set updated.  Please note that if we select Server A defacto the database will be EDW and if we select the server B, the database will be EDW_2.

     

    Thank in advance for your help.