I've defined a parameter which I use to create a dynamic query and I'd like to display its current value into my report for example using a card: I've enabled "parameter loading" option in Modify Query and all works fine in power bi desktop: once I've changed parameter value I refresh data and the new parameter value is correctly displayed in my card.
Unfortunatelly, after having uploaded my report into Power BI Service,changed my parameter value (Settings -> MyDataset -> Parameters -> Apply), refreshed the dataset, refreshed the report....displayed parameter value isn't updated!!!
I'm on the horns of a dilemma, I seems to have forgotten nothing...any clue?
Thanks a lot in advance
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.
In my report, when parameter value is 6, and the report is
Then I change my parameter value to 4 refresh the dataset
Then refresh the report again.
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
I will explain to you according to my report.
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]))
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.
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.
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
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
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?
In Edit Query I've enabled Loading option (right-click on parameter) so I can add it in my report. Of course I can share my pbix test file, where should I share it?
Thank you for your feedback, and I have reported it internally to Power BI Team: CRI 92912840.
If there is any update, I will post it here.
I have asked for the product team about this feedback, and this problem Hasn't been solved.
I'm sorry to have kept you waiting so much, and if there is any update, I will post here.