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

af2976ab f95e-4da7-86f6-c99799cf2780 on 05 Jul 2020 23:26:19

RE: Power BI Online Query Parameters

Please can we add this feature as it'll allow users to change parameters set in Power BI desktop.

Adam Kruzel's profile image Profile Picture

22050182 214a-418a-95e8-5efce8f5c069 on 05 Jul 2020 23:24:18

RE: Power BI Online Query Parameters

This feature is one of the major drawbacks after it is published.

Adam Kruzel's profile image Profile Picture

87ab1e8c 5c78-4d88-89d3-e726cd1684b0 on 05 Jul 2020 23:19:03

RE: Power BI Online Query Parameters

Hope to see it soon

Adam Kruzel's profile image Profile Picture

9287bba3 7d9b-4066-b0d5-249cf47ee426 on 05 Jul 2020 23:17:49

RE: Power BI Online Query Parameters

Check this out https://community.powerbi.com/t5/Community-Blog/Using-the-Power-BI-Service-Parameters-to-change-connection/ba-p/392016#comment-on-this

Adam Kruzel's profile image Profile Picture

9287bba3 7d9b-4066-b0d5-249cf47ee426 on 05 Jul 2020 23:17:49

RE: Power BI Online Query Parameters

I hope to see this in Power BI report server

Adam Kruzel's profile image Profile Picture

482b8d2e 941b-469b-af55-ee16399ad9aa on 05 Jul 2020 23:17:21

RE: Power BI Online Query Parameters

This need only be a Setting of the Dataset on Power BI.com

I don't want my end users to be fiddling around with parameter values that can make major changes to what is seen. However, as a manager of the service this would be useful.

For instance I have a boolean parameter to use "dev sources" or not.

Adam Kruzel's profile image Profile Picture

69b85c4a 5f22-4749-93e2-40c0d5cd7045 on 05 Jul 2020 23:14:50

RE: Power BI Online Query Parameters

I hope this functionality coming soon

Adam Kruzel's profile image Profile Picture

5369f9fb c610-4d6b-b756-c03ad3de2f13 on 05 Jul 2020 23:13:54

RE: Power BI Online Query Parameters

Its one of the most essential features of any reporting tools available in the current market. SSRS have this for years now. Almost, all other reporting tools such as Tableau, qlikview has this. This makes me think, "Why cant I just use MS Excel instead"

Adam Kruzel's profile image Profile Picture

82387b1e 2804-4463-a6e7-2a564937c4ea on 05 Jul 2020 23:12:30

RE: Power BI Online Query Parameters

This prevents us to migrate from Tableau to Power BI, since we regularly use parameters when publishing workbooks to Tableau Server. In our case, this is especially an issue since we use SQL Server Stored procedures as data sources for many reports/dashboards. Without access to parameters Online, we are stuck with static dashboards and reports.

Adam Kruzel's profile image Profile Picture

c31f55a5 ed3b-4e90-b055-68983cb5aa30 on 05 Jul 2020 23:11:43

RE: Power BI Online Query Parameters

We are trying to use Power BI with some of the big data connectors like Spark, but big data with Power BI is useless without allowing dynamic parameters.