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

6ffe469f 779b-41ee-86e0-ecb8a9f69782 on 05 Jul 2020 22:35:47

RE: Power BI Online Query Parameters

This is a very important feature as most of our users are not IT savvy and have the ability to use the desktop version, we want to control the reports through online parameters such as connection to env, report query parameters etc.

Adam Kruzel's profile image Profile Picture

0232c9e8 5985-4bd7-8dd6-00fd510aaa24 on 05 Jul 2020 22:31:31

RE: Power BI Online Query Parameters

As much as I'd like to consider a PowerBI solution, the lack of runtime params is a deal breaker. Any analytic tool set should contain this basic functionality.

If I've missed something, please educate us.

Adam Kruzel's profile image Profile Picture

1f7f2711 5819-e611-80e2-c4346bad91c4 on 05 Jul 2020 22:26:36

RE: Power BI Online Query Parameters

In my view, if Power BI allow for slicers to go across pages of a report, I could create the first page of my report to be a "parameters" page, where users would select the firsts that would go across the entire report-viewing session: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9861216-allows-slicers-to-apply-to-all-pages-of-a-report

For instance the first page of the report could have slicers for users to select the period (year, month, etc) customers, country/region, etc. Then since the slicers would go across the entire report, the other pages would show the data based on those "parameter slicers".

Adam Kruzel's profile image Profile Picture

2b0bfbea 2b9a-488b-9ff8-5f1de5d19406 on 05 Jul 2020 22:25:50

RE: Power BI Online Query Parameters

Yes, this is the #1 feature currently limiting the use of Power View for my clients. Effectively, it's still a summary tool only until we get runtime parameters. So we're still using RS

Adam Kruzel's profile image Profile Picture

1f7f2711 5819-e611-80e2-c4346bad91c4 on 05 Jul 2020 22:22:04

RE: Power BI Online Query Parameters

Agreed!

While the addition of parameters in queries is quite nice, it has no value for those of us using DirectQuery to on-prem datasources such as SSAS servers.

What my users want to see is parameters for opening reports based on SSAS tabular models.