Skip to main content

Power BI

Needs Votes

Power BI Online Query Parameters

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

b1dc80eb ed5c-4301-b5bf-056e39487436 on 05 Jul 2020 23:11:17

RE: Power BI Online Query Parameters

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

Adam Kruzel's profile image Profile Picture

82032750 c60e-4e8c-9bb2-47d67e5d01fe on 05 Jul 2020 23:10:39

RE: Power BI Online Query Parameters

This is functionality is absolute must for us to migrate to Power BI from SSRS

Adam Kruzel's profile image Profile Picture

d9afb18d 9e94-4cb0-904e-bdeb7ee0eb56 on 05 Jul 2020 23:10:35

RE: Power BI Online Query Parameters

This is a real blocker for us to migrate from SSRS.

Adam Kruzel's profile image Profile Picture

161b5947 d770-4bce-b151-cf0dcb6b6d2c on 05 Jul 2020 23:10:30

RE: Power BI Online Query Parameters

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

Adam Kruzel's profile image Profile Picture

ae292192 230a-4ee3-be95-8ace11adefbc on 05 Jul 2020 23:06:02

RE: Power BI Online Query Parameters

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.

Adam Kruzel's profile image Profile Picture

bb4b1e0d d3b1-4465-a609-4d1c2c3ead0e on 05 Jul 2020 23:05:33

RE: Power BI Online Query Parameters

Any update on this idea? This from 2016..Hoping there is progress as we are now nearing the end of 2017.

Adam Kruzel's profile image Profile Picture

9e4e7764 a627-4958-8f89-7271d8434b31 on 05 Jul 2020 23:05:02

RE: Power BI Online Query Parameters

We cannot move away from SSRS and start using Power BI Report Server without this functionality.

It is absolutely a deal breaker, and it cannot come soon enough.

We are presented with the solution to use slicers on the report, however that doesn't cut it when we have a lot of data in the back end it just isn't responsive and we have excruciating load times.

Adam Kruzel's profile image Profile Picture

1f7f2711 5819-e611-80e2-c4346bad91c4 on 05 Jul 2020 23:01:09

RE: Power BI Online Query Parameters

'@Gowtham Veera Raghavan commented ยท July 04, 2017 07:42
You have a point there! I agree with you.

Adam Kruzel's profile image Profile Picture

95b43b31 986f-4b58-8e96-3b2c3c89003e on 05 Jul 2020 23:01:04

RE: Power BI Online Query Parameters

This is a killer functionality that are already present on Tibco Spotfire that block us to migrate to power bi.

Adam Kruzel's profile image Profile Picture

95b43b31 986f-4b58-8e96-3b2c3c89003e on 05 Jul 2020 23:01:03

RE: Power BI Online Query Parameters

This is a killer functionality that are already present on Tibco Spotfire that block us to migrate to power bi.