Forum Discussion

laciodrom_80's avatar
laciodrom_80
Helper IV
7 years ago

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 i...
Need Help
Tutorial Requests
Romain_FOURNIER's avatar
Romain_FOURNIER
Frequent Visitor
7 years ago

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 !

 

 

laciodrom_80's avatar
laciodrom_80
Helper IV
7 years ago

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?

  • Romain_FOURNIER's avatar
    Romain_FOURNIER
    Frequent Visitor
    5 years ago

    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

  • Jaweed's avatar
    Jaweed
    Helper III
    7 years ago

    I totally agree. Cannot use power bi desktop as a work around, as the users should be able to run the report as per their requirements, ie pass the parameters. 

    hopefully Microsoft sorts out soon. I am running a debtors aging report as as at 31Aug 2019, which I pad as a parameter, but the title still displays the wrong date, as at a previous parameter, which misleads 15 users. Why this problem remains unsorted over months now, I wonder.

    • pearl2's avatar
      pearl2
      Regular Visitor
      2 years ago

      I am facing this issue even in the Powerbi-desktop. Please highlight if I am missing something. If the field value comes directly from the datasource, only one refresh is enough. but if I use the parameters I have created to update the report. Then its a problem

      Any advice is much appreciated.

      Thanks