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.

[mwiggins]

Awesome news, looking forward to this!!

[USG_Phil]

Great news!!

[rajeevac]

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!

[mark40]

Great news! Thanks @Miguel

[wouter_kessene2]

Superb. Please provide some more insight, ie a hyperlink to documentation.

[akruzel]

I completely agree with Adam's comment below and have create a new posting here: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13820190-power-bi-online-query-parameters

[pbiideas1]

Miguel Llopis, this does not fully satisfy the request! We need powerbi online end users to be able to input parameters which will allow us to show them small parts of massive datasets. I can do everything the new "parameter" feature does in SQL

[pedro8]

This is nice but all I see is parameters for queries when bringing data into a Power BI model. What about parameters for when viewing Power BI reports that are based on DirectQuery? That is, when connected to an on-premise dataset.

[9188040d-6c6257]

Microsoft , Show me 1 article, where it outlines step by step on using a parameter to filter data? Its not available. STOP lying to the public!!!

[pedro8]

Regarding my previous comment (RE: parameters for DirectQuery reports): In my view, if Power BI allow for slicers to go across pages of a report, I could create the first page of my report to be a "parameters" page, where users would select the firsts that would go across the entire report-viewing session: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9861216-allows-slicers-to-apply-to-all-pages-of-a-report For instance the first page of the report could have slicers for users to select the period (year, month, etc) customers, country/region, etc. Then since the slicers would go across the entire report, the other pages would show the data based on those "parameter slicers".