Skip to main content

Power BI

Needs Votes

Power BI Online Query Parameters

Vote (1067) 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

Power BI User 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

Power BI User 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

Arun Singh 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

Arun Singh 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

Power BI User 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

Carlos 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

Power BI User 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

Charles 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

Power BI User 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.

Adam Kruzel's profile image Profile Picture

Power BI User on 05 Jul 2020 23:11:17

RE: Power BI Online Query Parameters

Current parameter feature is almost useless. It cannot be used form power BI service. Changing the parameters is basic need of any reporting tool. Please add this feature.......