cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BenDenham Frequent Visitor
Frequent Visitor

Query parameter not updating

I am currently using a parameter list in one of my reports. This parameter list is generated from a table I have in SQL Server.

 

The issue I am having is that when I refresh my report this parameter list doesn't update.

 

Interesting, if I go into the Query Editor and refresh the query using "Refresh preview", the parameter list is sucessfully updated. It seems strange how the parameter list is updated when I refresh in Query Editor but not when I refresh on the Report.

 

Has any one else has this issue? Are there any workarounds/settings I could try?

 

Many thanks,

 

Ben Denham

6 REPLIES 6
Community Support Team
Community Support Team

Re: Query parameter not updating

Hi @BenDenham,

 

Have you turn on the "include the report refresh" option? if you not, these data doesn't refresh when you use refresh button at report view.(they will refresh when you choose this query and use refresh preview button at query editor)

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
BenDenham Frequent Visitor
Frequent Visitor

Re: Query parameter not updating

I do have "include the report refresh" enabled. The list is successfully being updated when I press the refresh button, but the parameter that uses this list (I have set Suggested Values to Query) is not being updated.

Community Support Team
Community Support Team

Re: Query parameter not updating

Hi @BenDenham,

 

Perhaps you can try to turn on the below feature to enable the parallel loading, then modify the query sort index to let the parameter list update before the custom function:

 

5.PNG

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
Highlighted
mohanjr Frequent Visitor
Frequent Visitor

Re: Query parameter not updating

I'm seeing the same issue.  After doing some testing, it appears that the Parameter's Query List is directly referencing the data available in the Query Editor's previewer, instead of refrencing the data on the front-end reporting side.  This picture below shows an example where I'm giving the user a list of dates to pick from, but the drop-down list they can see is dependent on the list options currently active in the Query Editor, instead of the list on the report.

 

I think what everyone is expecting is that doing a normal refresh of the data would also update parameter query options. It doesn't feel natural to need to also go to the back-end and refresh the Query Editor's preview to update to your parameter options.

 

I'm assuming this was a design decision by Power BI dev team since typically you wouldn't expose the query list on the front-end, but they'd still want the Parameter options to be available even if the data wasn't loaded into the report.  I'd advocate for the behavior of forcing the query list to be in the reporting layer since we still have the option to hide the data from the Report View.

 

 

PowerBI_Parameter_1.PNG

 

 

 

 

patlaff Frequent Visitor
Frequent Visitor

Re: Query parameter not updating

Has there been any movement on this issue? I'm having the exact same problem, and it seems to negate the advantage of having a query-driven parameter.  Any input from the Power BI Team?

_ai_ Frequent Visitor
Frequent Visitor

Re: Query parameter not updating

No update on this? I just tried this and was surprised that my Query to populate the parameter list was executed on launching the report template but the dropdown list was still the "old" one from the time the template was saved. What's the point of using a query in parameters when the contents of the parameter list don't get refreshed when you launch the report template?

 

Moreso, the paramater value is part of a second data source which is used to build a data source link dymanically when the template is launched based on user input. Since the parameter in question changes frequently, the dropdown list needs to change frequently as well and using a query to pull the values from where they are listed was a nice way to achieve this or would be if it would actually show the most up to date values in the dropdown. This very much looks like a bug.

 

 

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)