Skip to main content

Power BI

Needs Votes

Power BI Online Query Parameters

Vote (1068) Share
Adam Kruzel's profile image

Adam Kruzel on 12 May 2016 22:19:58

This is a continuation of "Allow runtime parameters in Power View and/or Power Query". Request this capability in Power BI Online so users can go to a dashboard and easily be able to search for a list of values. Currently the user would need to use a slicer and individual select each value. An example would be if I had list of part numbers to search in the dashboard. Currently I would need to scroll up and down in a slicer and individually select each one. In SSRS I can create a parameter dropdown and easily type in and even copy and paste values in to search for.

Comments (94)
Adam Kruzel's profile image Profile Picture

Vikas Reddy on 05 Jul 2020 23:57:24

RE: Power BI Online Query Parameters

This is absolutely essential, I am not sure why this has not been done till now.

Adam Kruzel's profile image Profile Picture

Gandhi C on 05 Jul 2020 23:54:53

RE: Power BI Online Query Parameters

Need user to change value of parameter in Power BI service for data refresh. Currently using Settings/parameter to change values for the dataset. But only 1 user can use this at a time, for when the 2nd user refreshes dataset, the first user's parameterized report gets refreshed with new data as data set gets refreshed. It is also a cumbersome set of steps for business user to go through these steps, which would be standard feature in most reporting tools.

This is becoming a no-go issue to propagate use of PowerBI by larger user base.

Adam Kruzel's profile image Profile Picture

Gaurav Joshi on 05 Jul 2020 23:54:36

RE: Power BI Online Query Parameters

Major blocker for enterprise level reporting of big data. Please pick up this idea, team. Thanks.

Adam Kruzel's profile image Profile Picture

Tobias Dirksen on 05 Jul 2020 23:51:52

RE: Power BI Online Query Parameters

Any update on this?

Adam Kruzel's profile image Profile Picture

Haibin Liu on 05 Jul 2020 23:51:46

RE: Power BI Online Query Parameters

please include this in next Power BI Online release. Thanks, Power BI team!

Adam Kruzel's profile image Profile Picture

Sandor Csurgo on 05 Jul 2020 23:51:42

RE: Power BI Online Query Parameters

urgent... must have... upvoting

Adam Kruzel's profile image Profile Picture

Mahmoud doudah on 05 Jul 2020 23:50:57

RE: Power BI Online Query Parameters

***URGENT***
I need to let end-user enter Parameter value !?

https://community.powerbi.com/t5/Desktop/Let-End-User-change-parameter-Value-every-Refresh-of-Power-BI/m-p/714652/highlight/false#M344871

mdoudah@istnetworks.com

WhatsUP--+966545495598

Adam Kruzel's profile image Profile Picture

Mahmoud doudah on 05 Jul 2020 23:50:57

RE: Power BI Online Query Parameters

anybody have any workaround !!
Let End-User change parameter Value every Refresh of Power BI Service

https://community.powerbi.com/t5/Desktop/Let-End-User-change-parameter-Value-every-Refresh-of-Power-BI/m-p/714652/highlight/false#M344871

mdoudah@istnetworks.com

WhatsUP--00966545495598

Adam Kruzel's profile image Profile Picture

Sudhakar on 05 Jul 2020 23:49:34

RE: Power BI Online Query Parameters

Please have the dynamic input parameters in PowerBI service like SSRS. This way, I can easily pass my input to get the result.

Adam Kruzel's profile image Profile Picture

Power BI User on 05 Jul 2020 23:48:22

RE: Power BI Online Query Parameters

Indeed one most useful feature.