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.

[jbuhro]

Without this feature, PowerBI is a non-starter for ISV's trying to embed.

[dadaras]

must have feature

[olsengrantm1]

Must have! We are trying to replace our Business Objects server and do not want to pull a 200 million record dataset then filter. Having this would be great to limit the dataset!

[Jaroslav_Jancik]

Yes, this would be very usefull. Or any other way to parametrization Power Query from Reports 🙂

[fbcideas_migusr]

Hope to see it soon

[hcgv]

We need this feature for sure as we have to make huge DB design changes and take dirty approach to design our backend

[noyb1]

Please allow online parameters ASAP! This is a show stopper for our plans to migrate to PowerBI in an O365 environment!!

[twiegelman]

A year later and the post below by an Anonymous User still has validity... When will Power BI Service allow us to change parameters that will refresh the data in the Model? I want to enter a date or dates and pass that to a Stored Procedure, function or View in SQL Server and have the underlying data inside the model refreshed. I do not want to have to load every available permutation of the data into a model and then create an extremely long List tied into a slicer to filter the data - make it a Live Query just like the name says! "Anonymous commented · February 28, 2018 12:19 Its one of the most essential features of any reporting tools available in the current market. SSRS have this for years now. Almost, all other reporting tools such as Tableau, qlikview has this." Make the Power BI Service GREAT by giving us this ability!

[waqaszubairy]

This will be good if we can change query parameter online, the only other way is to download PBIX file which can be huge in size which is not feasible everytime

[Ulen_Neale]

We have several hundred reports which use Crystal report which we want to migrate to Power BI. The vast majority of them use date range parameters. This is an absolute must-have in order for us to transfer our reporting solution into Power BI. I find it odd that such a simple requirement which has been asked for now for several years appears to still be missing.