Power BI Online Query Parameters

[akruzel]

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.

[pedro8]

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.

[info33]

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

[pedro8]

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".

[Shawn_Shriver]

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.

[ranjan_mishra]

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.

[deanco]

Please add this functionality soon. I have customers who would love to use this feature.

[lasse_soerensen]

I agree, this is highly needed

[gowthamveera]

'@Pedro Innecco, May be you are right. But when you don't want to show the data to client. then probably your solution is point less. Consider this situation, based on the user input, your data should get loaded into data model. So, where did this input comes from ? may be from SP returning output and injecting that output as a input to power BI as parameter. So, there is no point in slicer in this situation. Slicer will usually filter data throughout the data model. that's not the solution for every case.

[gowthamveera]

'@Adam Kruzel, Any update on this ?

[pieter_hebben]

This is indeed a major shortcoming in Power BI. HANA input parameters are not only used for filtering data, but also for security and currency/unit conversion.