Skip to main content

Power BI

Needs Votes

Power BI Online Query Parameters

Vote (900) 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 (85)
Adam Kruzel's profile image Profile Picture

a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 23:58:20

RE: Power BI Online Query Parameters

This is a super important and will add much needed functionality for end-users

Adam Kruzel's profile image Profile Picture

eda9515d 24e1-4fb4-924e-1c698928977a 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

bb68f9bd 6cc8-4c5b-8359-1d33924d5a23 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

a9a5036e e414-4dec-8cf2-97ee22ac9b76 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

dd11ac42 c871-4f43-b2c4-c997ebc70490 on 05 Jul 2020 23:51:52

RE: Power BI Online Query Parameters

Any update on this?

Adam Kruzel's profile image Profile Picture

081c59ef d190-4992-a8aa-a5b72be57944 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

d00abd20 78f1-4be1-a8fe-e763c22c240d on 05 Jul 2020 23:51:42

RE: Power BI Online Query Parameters

urgent... must have... upvoting

Adam Kruzel's profile image Profile Picture

6a8c71ad e206-4857-93c2-1852322ade94 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

6a8c71ad e206-4857-93c2-1852322ade94 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

93a55c84 3fc4-44d5-84fe-bf641dec5629 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.