Change parameter values within direct query sources

[martin_spaldin3]

Currently you can only change parameter values online within imported data sources, this would be useful to have on direct query and live connection data sources also as the ability to move through environments without redeploying is very useful for organisations.

[Subhash_Marti]

This is definitely needed as currently we can not use the data source dynamic parameters.

[Chris_Borden]

Here we are in March of 2023 and the limitations on PowerBI parameters is still here.

Your hands are basically tied with respect to presenting parameter options to users of published reports.

In my case, I've got a stored procedure that returns records for a given year. I have a default/current year, but I want users to be able to select from a dropdown too. This sounds exceedingly simple.... and almost all instructions / guides for using this parameter in a dynamic query completely miss the mark & ignore the UI aspect of how to change the value.