Forum Discussion
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.
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?