Parameters now working in service

[Anonymous]

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

[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

[v-xicai]

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.

[Greg_Deckler]

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?

[Anonymous]

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?

[Anonymous]

@Greg_Deckler 

Please find the highlighted Filtered rows for Parameter 

[Greg_Deckler]

Also if you really think it is an issue with the Service and query parameters, You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".

[Greg_Deckler]

Yep, that looks correct. Are you sure your refresh succeeded? If you go into the dataset and create a new report in the Service, do you only see Enterprise data?

Is this the only table in your data model? Could some other table also need updated?