Passing Parameters to Power BI through Stored Procedure

[v-kumdee]

There Should be Provision of passing the Parameter to the report like we do in SSRS Reports. There should be any method to execute Stored Procedure by passing the Parameters

[jon_collis1]

This would be great as we have a number of reports that we leverage that pass parameters to a stored procedure (such as date ranges etc.) It would really open up a world of opportunities.

[rafal_kun1]

It would also be great to pass the parameter to an sql in Power BI

[shawn_gotfredso]

Qlikview can do it 😉

[tim_douglas]

Crazy this doesn't exist already.

[gareth_owen1]

to allow for data abstraction and agnostic data sources it would be great if Power BI could easily retrieve data from stored procedures with parameters, that are easy to input by a user, not the static query option that is currently available. SSRS allows this option, Power BI should also.

[alexander_proos]

Nice idea

[sam_straube]

With the increasing amount of data in many databases, there is increasing demand with my customers to filter the data dynamically and perform other intelligence using stored procedures.

[shane10]

This needs to be available. Only passing parameters into a template when the report is opened is of little use. Should be able to use Slicers to pass the value to parameters for Stored Procs

[mvanberkel]

Hopefully this will be implemented soon.

[ansonantony]

please update when this can be expected.