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)
RE: Allow runtime parameters in Power View and/or Power Query
Great news! Thanks @Miguel
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!
RE: Allow runtime parameters in Power View and/or Power Query
Good news!
Waiting for this..
RE: Allow runtime parameters in Power View and/or Power Query
Awesome news, looking forward to this!!
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!
RE: Allow runtime parameters in Power View and/or Power Query
Great news!!
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 ?
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)
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
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.