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
Hello Mr. Llopis,
how can this be achieved right now and when will the "easy-version" be available?
RE: Allow runtime parameters in Power View and/or Power Query
Great news about this feature, was just being asked if I could do this today
RE: Allow runtime parameters in Power View and/or Power Query
Allow me to share a variable between queries. For example, so the source table of an Azure table could be changed in all the queries at once instead of requiring each query to be updated.