Query Parameter Refresh Issue

Hello Xue Ding,

Thanks for the response, but unfortunately waiting for at least 30 minutes after changing parameter value and then refreshing the dataset and report did not work.

As mentioned earlier, the report data getting successfully refreshed with the new parameter value, however I am also showing the parameter value itself on the report - which is not getting updated.

Let me try to give an example -

Scenario

I am passing quarters as parameters (20194 is for 4th quarter of 2019, 20201 is for 1st quarter of 2020 and so on) to filter data from the source. The parameter value is also displayed on the report to make users understand which quarter the report is for.

Outcome on Power BI desktop

While changing parameter value (from 20194 to 20201) and refreshing on desktop, everything works as expected - data is updated for 20201 as well as the period (the parameter value itself) is showing on the report as 20201.

Issue on Service

The report gets refreshed on the service using an enterprise gateway - and there is no problem with the refresh. However, while changing the parameter on service (same example - from 20194 to 20201), after applying the change and waiting for 30 minutes as suggested - when I refresh the report, the report data is getting successfully updated as per the new parameter value (20201) but the period field is still showing the old parameter value (20194).

The only workaround at the moment is to download the pbix file, refreshing and republishing which is not suitable for the end users.

Our data source is a SAP BW system.

It seems to be a bug for the Power BI service.

Looking forward for your help on this!

Regards,

Rishiraj

v-xuding-msftGilbertQ nickyvv Greg_Deckler