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
'@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.
RE: Allow runtime parameters in Power View and/or Power Query
any update on this ?
RE: Allow runtime parameters in Power View and/or Power Query
Agree, need this input to refresh.
RE: Allow runtime parameters in Power View and/or Power Query
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.
RE: Allow runtime parameters in Power View and/or Power Query
Not completed !!! we need a run time parameter that end user the select at run time
RE: Allow runtime parameters in Power View and/or Power Query
I am using a direct query to have a data set that I create from a stored procedure and would like the capability to pass a date parameter to the stored procedure so that when query executes, it returns that appropriate data.
I have not seen a way to create a parameter that can be passed into a direct query.
I can create the direct query calling the stored procedure but have to hard code the date that I want returned from the data set. which kind of defeats the purpose of having dynamic data when running a report.
I can accomplish the same with static data sets.
Has anyone found a work around for this?
RE: Allow runtime parameters in Power View and/or Power Query
Not completed!
there is difference between making the data set parameterized and giving the possibility to change that parameter runtime by end user.
RE: Allow runtime parameters in Power View and/or Power Query
Not completed, can not select parameter on runtime
RE: Allow runtime parameters in Power View and/or Power Query
I am able to pass a parameter to a script but I am not seeing how I can have this list of parameter values as a drop down on my report. Can this be done>
RE: Allow runtime parameters in Power View and/or Power Query
Hi, Is it possible to change the variables during run time?i.e, depending on the value from the drop down in the Power BI report, the HANA variable or filter should change.