Forum Discussion
Referenced Query is not updating
I sent this same response in this thread regarding this behavior: https://community.powerbi.com/t5/Desktop/Query-parameter-not-updating/td-p/181609
______________________________________________________________________________________________________
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 included in the report refresh. I'd advocate for the behavior of forcing the query list to be in the reporting layer and included in report refresh since the user still has the option to hidethe data from the Report View.