Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric Ideas just got better! New features, better search, and direct team engagement. Learn more

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.
Status: Needs Votes
Comments
bt_avalonbay
Advocate I
Adding vote with clear reason: A Power BI model with multiple temporal fact tables/views that all have From/Start and To/End dates and use cases that will always require a specific run date to qualify the rows returned. A date picker combo box would be a nice as well. Support for temporal tables is going to be a must moving forward.
databases_sql
New Member
This is a real blocker for us to migrate from SSRS.
saileekumawat
Advocate I
Current parameter feature is almost useless. It cannot be used form power BI service. Changing the parameters is basic need of any reporting tool. Please add this feature.......
raj1_veer
Frequent Visitor
This is functionality is absolute must for us to migrate to Power BI from SSRS
elizabeth_willi
New Member
We are trying to use Power BI with some of the big data connectors like Spark, but big data with Power BI is useless without allowing dynamic parameters.
chris_vanveluwe
New Member
Current parameter feature is almost useless. It cannot be used form power BI service. Changing the parameters is basic need of any reporting tool. Please add this feature.......
charlessaulnie1
New Member
This prevents us to migrate from Tableau to Power BI, since we regularly use parameters when publishing workbooks to Tableau Server. In our case, this is especially an issue since we use SQL Server Stored procedures as data sources for many reports/dashboards. Without access to parameters Online, we are stuck with static dashboards and reports.
ajjurasam1
New Member
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. This makes me think, "Why cant I just use MS Excel instead"
carlos_balleste
New Member
I hope this functionality coming soon
Arunsingh
Frequent Visitor
Check this out https://community.powerbi.com/t5/Community-Blog/Using-the-Power-BI-Service-Parameters-to-change-connection/ba-p/392016#comment-on-this