Power BI

Needs Votes

Passing Parameters to Power BI through Stored Procedure

Vote (541)

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 (56)

Gary Thomann on 05 Jul 2020 23:51:57

RE: Passing Parameters to Power BI through Stored Procedure

Lol. Vote on all the duplicate threads as per below. 'the noisy wheel...'
Every other reporting platform can do it! Even my Grandma can do it :)

marco on 05 Jul 2020 23:46:23

RE: Passing Parameters to Power BI through Stored Procedure

Cant believe by now it still not possible to use slicers and pass the value to parameter.

Power BI User on 05 Jul 2020 23:45:30

RE: Passing Parameters to Power BI through Stored Procedure

@Rose Spitzer Is there any update on this feature? Please let us know!

Eugene Harvey on 05 Jul 2020 23:45:07

RE: Passing Parameters to Power BI through Stored Procedure

It would be great to know if this is in the pipeline or something being considered as it is the one thing holding back the use of PowerBI as a proper enterprise reporting solution in the same manner that SSRS is.
The functionality is all there to embed PowerBI Models into an ASP.NET application through the use of URL strings, similar to using the SSRS ReportViewer Control, but unlike the SSRS Report Viewer Control, you can't pass parameters to the behind SQL query for PowerBI which enables query driven row level security routines, whether stored procedure or not. Using parameter collections to pass to the PowerBI query would greatly improve efficiency and performance as on the data required by the user is returned.
Ideally I would like to use all PowerBI Models in Direct Query mode where the ASP.Net application user is identified and only data for that user is returned, even a single parameter would help where the User Credential is passed to the SQL Query.

Power BI User on 05 Jul 2020 23:44:30

RE: Passing Parameters to Power BI through Stored Procedure

This is absolutely essential, I am not sure why this has not been done till now

Chihiro Kanai on 05 Jul 2020 23:42:59

RE: Passing Parameters to Power BI through Stored Procedure

This would be handy to have. Currently I need to create view via Table Valued UDF and query the view.

Riccardo Di Prima on 05 Jul 2020 23:41:58

RE: Passing Parameters to Power BI through Stored Procedure

I want to pass parametres to a query in Poweb BI. For example

SELECT Anno, Dimensione, SUM(Importo) Importo
FROM HCI_POWERBI_PrenotazioniPerDimensioni(@Parametr1,@Parameter2)
GROUP BY Anno, Dimensione

Thomas Wiegelman on 05 Jul 2020 23:41:14

RE: Passing Parameters to Power BI through Stored Procedure

I support 'Power BI Online Query Parameters' - what do you think? https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13820190-power-bi-online-query-parameters

Thomas Wiegelman on 05 Jul 2020 23:41:14

RE: Passing Parameters to Power BI through Stored Procedure

I support 'Power BI Online Query Parameters' - what do you think? https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13820190-power-bi-online-query-parameters

Pratik Thanki on 05 Jul 2020 23:40:13

RE: Passing Parameters to Power BI through Stored Procedure

Refer to this as the main Idea for this functionality to avoid duplication:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/20367082-passing-parameters-to-power-bi-through-stored-proc

Merged Idea (1)