Power BI

Needs Votes

Passing Parameters to Power BI through Stored Procedure

Vote (544)

Ankit on 02 Aug 2017 10:26:30

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

Comments (57)

Alexander Proost on 05 Jul 2020 23:15:59

RE: Passing Parameters to Power BI through Stored Procedure

Nice idea

Sam Straube on 05 Jul 2020 23:15:58

RE: Passing Parameters to Power BI through Stored Procedure

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.

Gareth Owen on 05 Jul 2020 23:08:10

RE: Passing Parameters to Power BI through Stored Procedure

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.

Tim Douglas on 05 Jul 2020 23:03:56

RE: Passing Parameters to Power BI through Stored Procedure

Crazy this doesn't exist already.

Shawn GOtfredson on 05 Jul 2020 23:03:06

RE: Passing Parameters to Power BI through Stored Procedure

Qlikview can do it ;)

RafalK on 05 Jul 2020 22:19:42

RE: Passing Parameters to Power BI through Stored Procedure

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

Jon Collis on 05 Jul 2020 22:17:42

RE: Passing Parameters to Power BI through Stored Procedure

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.

Merged Idea (1)