Skip to main content

Power BI

Completed

Allow runtime parameters in Power View and/or Power Query

Vote (152) Share
Ramu Kodemala's profile image

Ramu Kodemala on 26 Feb 2015 00:47:50

PowerView does not take input parameters at run time. In order to change the data being presented at runtime the user must use a filter or the query author must use a non-deterministic function in the query (e.g. MyDate = GETUTCDATE () ). Neither approach allows a user to create an optimal request that brings down just the data he/she wants to see. My understanding is that filtering in Power View requires the superset of data to be retrieved before the filter is applied. Nondeterministic functions do not provide the flexibility of parameters. This will be an important feature when dealing with datasets large enough to cause performance and/or stability issues.

Administrator on 07 May 2016 05:00:12

It is now possible to define Parameters in Power BI Desktop, annotating them with metadata (name, description, expected data type and allowed values), reference these parameters from your queries, data model and report elements (labels, etc.). We'll continue making incremental improvements on top of the existing Parameters feature - so if there are specific items that you would like us to do based on this feature, please cast your votes. : )

Comments (33)
Ramu Kodemala's profile image Profile Picture

Mark Henderson on 05 Jul 2020 22:20:02

RE: Allow runtime parameters in Power View and/or Power Query

Great news! Thanks @Miguel

Ramu Kodemala's profile image Profile Picture

Kristian Olson on 05 Jul 2020 22:19:58

RE: Allow runtime parameters in Power View and/or Power Query

Yes! This brings Power BI closer to being able to utilize stored procedures better in SQL! Cant wait to recreate all my SSRS reports with Power BI!

Ramu Kodemala's profile image Profile Picture

Michael Assouline on 05 Jul 2020 22:19:53

RE: Allow runtime parameters in Power View and/or Power Query

Good news!
Waiting for this..

Ramu Kodemala's profile image Profile Picture

Mark Wiggins on 05 Jul 2020 22:19:50

RE: Allow runtime parameters in Power View and/or Power Query

Awesome news, looking forward to this!!

Ramu Kodemala's profile image Profile Picture

Rajeev Acharya on 05 Jul 2020 22:19:50

RE: Allow runtime parameters in Power View and/or Power Query

This is brilliant! I am envisioning something like SSRS where you have reports with input boxes that are passed as filters for the query being executed. It's the one reason we haven't actively adopted PowerBI yet. Looking forward to this!

Ramu Kodemala's profile image Profile Picture

Phil Gonzalez on 05 Jul 2020 22:19:50

RE: Allow runtime parameters in Power View and/or Power Query

Great news!!

Ramu Kodemala's profile image Profile Picture

Ashish Ruparel on 05 Jul 2020 22:17:31

RE: Allow runtime parameters in Power View and/or Power Query

Hi Miguel,

This is also one of the important features that will set PowerBI apart.
Any SLA for implementing this ?

Ramu Kodemala's profile image Profile Picture

Mark Henderson on 05 Jul 2020 22:15:39

RE: Allow runtime parameters in Power View and/or Power Query

Could you use the filers attribute to achieve this? https://powerbi.microsoft.com/en-us/blog/power-bi-api-updates-roundup/ (see at the bottom)

Ramu Kodemala's profile image Profile Picture

Sherif on 05 Jul 2020 22:10:40

RE: Allow runtime parameters in Power View and/or Power Query

Hi, I have the same request, powerbi is a great tool and this will be a valuable feature

Ramu Kodemala's profile image Profile Picture

Imke Feldmann on 05 Jul 2020 22:09:05

RE: Allow runtime parameters in Power View and/or Power Query

Currently I’m using parameter tables in Excel to give the user the possibility to enter filters without needint to edit the code. This is not the greatest user experience so I’d very much appreciate the possibility to include this in the Power BI experience.