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)
RE: Power BI Online Query Parameters
Maybe with a setup option in order to hide the parameter from online change ?
RE: Power BI Online Query Parameters
highly needed and soon
RE: Power BI Online Query Parameters
Any update on this ?
RE: Power BI Online Query Parameters
Any update ?
RE: Power BI Online Query Parameters
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.
RE: Power BI Online Query Parameters
'@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.
RE: Power BI Online Query Parameters
'@Adam Kruzel, Any update on this ?
RE: Power BI Online Query Parameters
I agree, this is highly needed
RE: Power BI Online Query Parameters
Please add this functionality soon. I have customers who would love to use this feature.
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.