User enters values for query parameters

[Anonymous]

Question : Can Power BI allow users to enter values for query parameters  through slicers  in a custom parameterized query? The solution should  work on PowerBI.com ( online access , just not desktop version).

Even if someone have  connected to a database through ODBC or some scripting language and implemented a solution to the above , please share.Thanks

Sample Query

select datatable.* from table(date_compare(20200101,20200131,20190101,20190131))

inner join datatable

on date_id_curr = datecurrent and date_id_prev = dateprevious

where hour_id=3;

** datatable is a sample table

Similar Power BI query

"select datatable.* from table(date_compare(" & DATECURRENTSTART & "," & DATECURRENTEND & "," & DATEPREVIOUSSTART & "," & DATEPREVIOUSEND & ")) #(lf)inner join datatable #(lf)on date_id_curr = datecurrent and date_id_prev = dateprevious#(lf)where hour_id=3;#(lf)"

We know in Power BI Desktop,we can enter values for DATECURRENTEND, DATECURRENTSTART, DATEPREVIOUSEND and  DATEPREVIOUSSTART through Query parameters

But we want the end user to enter values for these parameters in Power BI .com

[v-alq-msft]

Hi, @Anonymous 

As a report creator, you define parameters in Power BI Desktop. When you publish the report to Power BI Service, the parameter settings and selections travel with it. You can review and edit parameter settings in Power BI Service, but not create them. You may edit parameters whose data type is not 'Any' or 'Binary'.

You may use query parameter to filter rows, parameterize a data source, loading dynamic columns from the data source and so on.

For further information, please refer to the following links.

Edit parameter settings in the Power BI service 

Power BI Desktop Query Parameters 

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , refer whatif parameter : https://docs.microsoft.com/en-us/power-bi/desktop-what-if

Refer how to use series when what if does not suits

https://youtu.be/9VYqbj2h4zE

https://community.powerbi.com/t5/Quick-Measures-Gallery/Financial-Magic-to-continue-with-10-Recently-added-Function/td-p/1233163

[Pragati11]

HI @Anonymous ,

Try looking into What-if parameters in POwer BI:

https://radacad.com/power-bi-what-if-parameters

Thanks,

Pragati