Forum Discussion
Query parameters displayed value doesn't refresh in Power BI Service
hi, laciodrom_80
After my research, It works well.
and for the cache problem, after you change my parameter value, you need to refresh the dataset first, then refresh the report again.
Then it will work well.
for example:
In my report, when parameter value is 6, and the report is
result is 31
Then I change my parameter value to 4 refresh the dataset
Then refresh the report again.
Best Regards,
Lin
Hi v-lili6-msft,
thanks for your suggestion but, if I've not misunderstood, in your report you are displaying the result of the query (initially 20 and then after refresh, 31), while I'm trying to display the parameters's value: so, in your case, you should try to display in your report the value 4 and then, after having refreshed the dataset and the report, you should be able to see value 6.
I've made exactly what you do "you need to refresh the dataset first, then refresh the report again" but I don't see the new parameter value displayed but always the old one :smileysad:
Best Regards
hi, laciodrom_80
I will explain to you according to my report.
For example:
This is my basic data
and I create a parameter and use it to filter data that is less than or equal to this parameter.
And in my simple report.
I just create a measure and drag it into card visual.
Measure = CALCULATE(SUM(Table1[Qty]))
Step1:
When i set parameter is 6, now the result is sum all ID is less than or equal to 6
and It is 11+2+3+4+5+6=31.
Then I change the parameter to 4 and refresh it, now the result is sum all ID is less than or equal to 4
and It is 11+2+3+4=20
It works well.
Step2:
Now I publish this report to service:
In the dataset setting, the parameter is 4 and the result is 20 in the report.
Then I change the parameter to 6, Apply and refresh dataset first.
and then refresh the report.
before refresh reportafter refresh report
Best Regards,
Lin
Hi v-lili6-msft,
I've just created your report and tryed it: yes it works like you say, but if you try to add into the report the current parameter value, you'll bump into the issue I say
I start with param value 4 and Qty 20
then I change parameter value:
I refresh the dataset, and the report and..... BAM!!!! I don't see "6" while Qty is correctly updated :smileyfrustrated:
Try to display also the parameter value....note that on Power BI Desktop all works fine, the issue seems to be only on Power BI Service
hi, laciodrom_80
How do you add parameter value into visual, whether the parametor is What if parameter?
What if parameter is not updated by data refresh, could share your test pbix file with us to do a test?
Best Regards,
Lin