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.
35 Comments
- 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. : )
- 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.
kazlikHelper II
Great news about this feature, was just being asked if I could do this today- Hello Mr. Llopis, how can this be achieved right now and when will the "easy-version" be available?
- 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.
- Hi, I have the same request, powerbi is a great tool and this will be a valuable feature
- 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)
- Hi Miguel, This is also one of the important features that will set PowerBI apart. Any SLA for implementing this ?
- 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!
- Good news! Waiting for this..
Recent ideas
executeDaxQueries-like API call with effectiveUserName on SSO-enabled model with Service Principal
Please provide a way for a service principal to execute DAX - with an effective user name - against an SSO-enabled directlake semantic model and get per-user results that respect lakehouse OneLake Se...
