Parameters now working in service

Question

Hi ,&nbsp;Im using excel as source to create a pbix report which is stored in one drive.&nbsp;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 reportRegards,Husna&nbsp;

greg_deckler · Answer

Not following this.&nbsp;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
&nbsp;
What do you mean change the default value?

anonymous · Answer

&nbsp;Hi&nbsp;Greg_Deckler&nbsp;,&nbsp;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&nbsp; didnt change to Enterprise . It was showing only MidMarket data&nbsp;&nbsp;&nbsp;Regards,Husna&nbsp;

greg_deckler · Answer

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 · Answer

Greg_Deckler&nbsp;Please find the highlighted Filtered rows for Parameter&nbsp;

greg_deckler · Answer

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?

Forum Discussion

Parameters now working in service

Related content

Decimal level parameter not working

Parameters in Power BI service

Service Parameter

Paginated Report with Parameter breaks in Service

Parameters not working in service