Forum Discussion
Query parameters displayed value doesn't refresh in Power BI Service
Hi all,
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!!! :smileymad:
I'm on the horns of a dilemma, I seems to have forgotten nothing...any clue?
Thanks a lot in advance
32 Replies
You can always reference the parameter and then convert it to a table. This is what I do to get a parameter value updated in my models.
I'm facing a parameter issue....this will not update every day please
Gregory_Felton wrote:You can always reference the parameter and then convert it to a table. This is what I do to get a parameter value updated in my models.
Thank you so much! 😀 This worked flawlessly
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
The only workaround I was able to find to get the parameter tile to update with the new value was to go to the Fields Pane, right click on the parameter, and click refresh data. The only problem with this is the data would refresh twice (Once to apply data and another to refresh parameter tile).
Same Problem here.
Something new of this issue?
The effect is guarantied only for refreshes done 30 minutes after the parameter change.
appreciate everyone everywhere
this is voodoo. this is hard to use. this is harder to own.
this is bad news, Microsoft. this is a bug. fix it.
I am facing this issue even in the Powerbi-desktop. Please highlight if I am missing something.
Any advice is much appreciated.
Thanks
I'm having the same issues as described above. My parameter tile will not update with the new value despite the data updating.
Hi,
To integrate the parameters updating in Power BI Desktop and Power BI Service, do this :
Go in PBI Desktop > Home, and click on the Refresh.
For instance :
You have the AgeLimit paramater in PBI Query Editor. Its value is 80.
When you go to PBI Desktop, if you show the parameter in the report, the value is 80.
You want to modify the AgeLimit parameter from 80 to 85.
You change the value in PBI Query Editor. If you look in PBI Desktop and in PBI Service, the value is still at 80.
Now, in PBI Desktop, click on Home > Refresh.
Thenceforth, the value in PBI Desktop will be updated to 85.
You only have to publish the report to update the value in Power BI Service.
Then, Power BI do not curiously update parameters by default. However, the updating is quite simple to do !
Hi Romain_FOURNIER ,
the solution you suggests couldn't be the right one, because power bi desktop is a development tool and it isn't acceptable to do a deploy every time a parameter value is changed in a report
v-lili6-msft any news from Power BI Team about this issue?
Hi Luca,
I agree with you: Microsoft must give a more appropriate way to refresh parameters easier.
I gave a palliative to temporarily unblock people until a lasting solution is delivered.
Romain
