Power BI Online Query Parameters
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.
Lamin Jobe commented
This is a super important and will add much needed functionality for end-users
Vikas Reddy commented
This is absolutely essential, I am not sure why this has not been done till now.
Gandhi C commented
Need user to change value of parameter in Power BI service for data refresh. Currently using Settings/parameter to change values for the dataset. But only 1 user can use this at a time, for when the 2nd user refreshes dataset, the first user's parameterized report gets refreshed with new data as data set gets refreshed. It is also a cumbersome set of steps for business user to go through these steps, which would be standard feature in most reporting tools.
This is becoming a no-go issue to propagate use of PowerBI by larger user base.
Gaurav Joshi commented
Major blocker for enterprise level reporting of big data. Please pick up this idea, team. Thanks.
Tobias Dirksen commented
Any update on this?
Haibin Liu commented
please include this in next Power BI Online release. Thanks, Power BI team!
Sandor Csurgo commented
urgent... must have... upvoting
Luis Higueros commented
when is this going to get fixed??
Mahmoud doudah commented
I need to let end-user enter Parameter value !?
Mahmoud doudah commented
anybody have any workaround !!
Let End-User change parameter Value every Refresh of Power BI Service
Please have the dynamic input parameters in PowerBI service like SSRS. This way, I can easily pass my input to get the result.
Indeed one most useful feature.
Craig Stuart commented
Eugene Harvey commented
The one and only thing holding back using PowerBI as an enterprise reporting solution for multiple users with PowerBI embedded in an ASP.Net Solution is the inability to pass parameters via the URL to the query behind in the PowerBI Model in that same manner you can do it in SSRS. PowerBI is a much better UI with UI interaction that SSRS, but we are stuck with SSRS until similar functionality is made available. It is such a shame as we would migrate many of our SSRS RDL's to PowerBI Model deployed under Power BI Report Server.
It must be coming as Power BI Report Server which has superseded SSRS Report Server.
This is blocking our use cases where we wanted to share the report with multiple people in my organization.
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
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.
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!
We need this feature for sure as we have to make huge DB design changes and take dirty approach to design our backend