Forum Discussion
Parameters now working in service
Hi ,
Im using excel as source to create a pbix report which is stored in one drive.
When i publish the report in service , im able to change the default value in service but the data is not filtered as per the new value.
After removing the default value which was Midmarket in service when i tried entering Enterprise and refreshed in service there was no change in report
Regards,
Husna
8 Replies
- Greg_Deckler
Community Champion
Not following this. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
What do you mean change the default value?
Hi Greg_Deckler ,
While creating parameter in Destop i selected the current value as MidMarket and published the report in service. When i changed the parameter to Enterprise and refreshed the dataset in service ,the data in the visual didnt change to Enterprise . It was showing only MidMarket data
Regards,
Husna
- Greg_Deckler
And you are using that Parameter in your Query? Can you paste your code from the Advanced Editor and call out where you have that parameter?
v-xicaiCommunity Support
Hi Anonymous ,
From your second picture, the "Apply" button is grey, that means this parameter is failed to set and won’t take effect. You may try to change "Suggested Value" using "List of value" option when setting parameter to test if it is due to other issue reasons .
For references:
https://docs.microsoft.com/en-us/power-bi/service-parameters
https://www.mssqltips.com/sqlservertip/4475/using-parameters-in-power-bi/
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- v-xicai
Hi Anonymous ,
Does that make sense? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.
Best regards
Amy
