Allow runtime parameters in Power View and/or Power Query

[RAMUK1]

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.

[ducthai]

Miguel how can you mark this as completed, IMCOMPLETED we need user input box so end user can type in or select value or text and then run the report on run time. It is not possible to do it in power bi destop as of today.

[michael_colber1]

Agree, need this input to refresh.

[gowthamveera]

any update on this ?

[matei_muntiu]

'@Miguel Llopis How can you achieve this? We need the user to be able to input the date and refresh. I am using a import query to have a data set that I've created from a stored procedure. And would like the possibility to pass a date parameter to the stored procedure so that when query executes it returns the appropriate data.