Skip to main content
Microsoft Idea

    Power BI

    Needs Votes

    Power BI Online Query Parameters

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

    Brad Baker on 05 Oct 2022 16:07:24

    RE: Power BI Online Query Parameters

    We absolutely need a way for the parameter to be changed by the end user and then have the data pull again. Even if the data is being pulled from the database directly.

    Adam Kruzel's profile image Profile Picture

    Dynamic Technology on 25 Jul 2022 12:13:05

    RE: Power BI Online Query Parameters

    100% needed.

    Adam Kruzel's profile image Profile Picture

    Viragkumar Jagtap on 07 Jul 2022 08:17:45

    RE: Power BI Online Query Parameters

    Most awaited feature. 100% needed.

    Adam Kruzel's profile image Profile Picture

    Cookie McCray on 04 May 2022 10:23:11

    RE: Power BI Online Query Parameters

    Would you be interested in joining our user research panel to influence the roadmap of the product? If so, join here

    Adam Kruzel's profile image Profile Picture

    Vahid Pournavab on 18 Mar 2022 04:21:55

    RE: Power BI Online Query Parameters

    This is 1000% needed!!

    Adam Kruzel's profile image Profile Picture

    Mauro RUFFINO on 18 Jun 2021 10:40:27

    RE: Power BI Online Query Parameters

    its important to have this features to improve RLS features. By exemple, if i embed a pbi visualization inside an external webapp, and i need that pbi visualization shows data based on a specifici item (e.g. BuildingID).

    Adam Kruzel's profile image Profile Picture

    Rob Hershfield on 06 Jul 2020 00:17:52

    RE: Power BI Online Query Parameters

    Enabling the user to modify stored procedure parameters is fundamental - has been around in reporting tools for 30+ years. Power BI is not ready for prime time without this capability.

    Adam Kruzel's profile image Profile Picture

    Sami Assi on 06 Jul 2020 00:15:30

    RE: Power BI Online Query Parameters

    Being able to pass parameter in an URL directly to a DirectQuery to filter teh data at the source is so important.

    we are currently using this:

    https://reportserver/reports/powerbi/Store Sales?rs:Embed=true&filter= Store/Territory eq 'NC' and Store/Chain eq 'Fashions Direct'

    But in this case, all data is brought to the report and then report is filtered.

    we need the data to be filtered at the source

    Adam Kruzel's profile image Profile Picture

    Power BI User on 06 Jul 2020 00:14:28

    RE: Power BI Online Query Parameters

    This is SO needed in order to make Parameters actually useful

    Adam Kruzel's profile image Profile Picture

    Silpa on 06 Jul 2020 00:14:16

    RE: Power BI Online Query Parameters

    We are migrating SSRS reports to Power BI. We are unable to build the dataset due to huge data. We need parameters(dynamic) to restrict the data