Can parameters be changed on the report page from an input area ?

[calman00]

Hi,

I am creating a dashboard for our sales people, and generating pulling data from a SQL server using old fashioned T-SQL queries. To change the SELECT value, I created a parameter that can be changed by clicking on Transform Data, then select Edit Parameters.

It works but :

- users have to click on the Apply Changes button everytime the parameter is being changed

- the Native Database Query prompt appears for each query, and users have to click Run three times (there are three queries)

is there a way to add a field on the report that could be used to change the query directly? 

The Native Database Query prompt I have not researched yet, but maybe this is not the right platform for this questions.

Thanks

[AdrienneB]

Did you ever find a solution for this? Thanks!

[calman00]

hello, my issue is not how to use the parameter in the query, I have this working.

My issue is to be able to let users change the parameter value directly on the report view, and not have to pull down the Transform Data menu and select Edit Parameters.

There are a lot of examples showing how to use field parameters as well, but it always refer to seleting values from a preset table or range.

There is also the issue that every time the parameter is changed, the Apply Changes" dialog pops up. Is there a way to avoid that :

Thanks

[amitchandak]

@calman00 ,

If this a direct query, you can use Dynamic M parameters

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters

or refer

https://www.fourmoo.com/2020/10/08/power-query-m-passing-parameters-dynamically-to-a-sql-server-quer...