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.

[9188040d-6c6257]

This is a complete Lie. Stop Lying Microsoft. There is no possible way, no instructions and no step by step on how to filter by using a parameter!!!

[fbcideas_migusr]

So, are there run time parameters or not?

[william_weber]

I would say that the current feature is NOT "runtime" parameters. We can include parameters in the query which is data load or data refresh parameters. Runtime would be something a user could select when they actual RUN the report.

[rafael15]

Hi Miguel, I have a model where part of the data is accessed via ODBC, and a few items via Excel. I would like to use parameters to define the path to the data, which can vary depending on the fiscal year. I have been able to 'parametrise' the path to the Excel file seamlessly. However, the ODBC connection dialog box does not show any way to include the parameter reference. I am using a DSN-less connection string and am trying to insert the path in a form similar to: driver = {Advantage StreamlineSQL ODBC};datadirectory={PathDatos};server=NotTheServer;defaulttype=Visual FoxPro;rows=False;language=ANSI;advantagelocking=ON;locking=Record;memoblocksize=64;maxtableclosecache=5;servertypes=1;trimtrailingspaces=False;encryptiontype=RC4;fips=False where 'PathDatos' is the name of the parameter. Is there a way to do this even if it means editing the Odbc.Query part of the M script? Many thanks, Rafael

[sandeept_deepu]

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.

[jane_cosler]

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>

[p_ghotra]

Not completed! there is difference between making the data set parameterized and giving the possibility to change that parameter runtime by end user.

[sajid_mansoor]

Not completed, can not select parameter on runtime

[dozersky]

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?

[ducthai]

Not completed !!! we need a run time parameter that end user the select at run time