Skip to main content
Microsoft Idea

    Power BI

    Needs Votes

    Power BI Online Query Parameters

    Vote (1063) 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 (93)
    Adam Kruzel's profile image Profile Picture

    Power BI User on 05 Jul 2020 22:57:29

    RE: Power BI Online Query Parameters

    highly needed and soon

    Adam Kruzel's profile image Profile Picture

    Abhishek Mishra on 05 Jul 2020 22:55:52

    RE: Power BI Online Query Parameters

    Any update on this ?

    Adam Kruzel's profile image Profile Picture

    rik on 05 Jul 2020 22:55:21

    RE: Power BI Online Query Parameters

    Any update ?

    Adam Kruzel's profile image Profile Picture

    Pieter Hebben on 05 Jul 2020 22:54:26

    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.

    Adam Kruzel's profile image Profile Picture

    Gowtham Veera Raghavan on 05 Jul 2020 22:52:55

    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.

    Adam Kruzel's profile image Profile Picture

    Gowtham Veera Raghavan on 05 Jul 2020 22:52:54

    RE: Power BI Online Query Parameters

    '@Adam Kruzel, Any update on this ?

    Adam Kruzel's profile image Profile Picture

    Power BI User on 05 Jul 2020 22:52:19

    RE: Power BI Online Query Parameters

    I agree, this is highly needed

    Adam Kruzel's profile image Profile Picture

    Dean Corcoran on 05 Jul 2020 22:49:50

    RE: Power BI Online Query Parameters

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

    Adam Kruzel's profile image Profile Picture

    Ranjan Mishra 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

    Shawn S 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.