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

[sbol1]

Agree with RafalK ;"It would also be great to pass the parameter to an sql in Power BI"

[conniecorredor]

This needs to work in Direct Query Mode. It should identify slicers and via direct query mode populate the slicers first similar to SSRS does. Then allow user to the slicers and then click on an view report button to execute the stored procedure with the selected slicers (parameters).

[t_wu]

This is a must feature for some of our reports. We are having timeout issue with the reports right now due to the fact that we have to retrieve all the transaction data to the report then do measures with DAX query. It would be much faster if we can use the slicer value as input and set it to a store proc for it to do all of these calculation on the database.

[eugene_harvey]

This is desperately needed so as to create robust and efficient on-premise deployable .NET solutions. We have created a web based Analytics solution embedding SSRS Reports using the Report Viewer control. Using the ASP.Net Application front end to collect parameters, these are passed to SSRS Report via the Report Viewer Control to populate the SSRS Template, with the parameters then passed to the SQL Query behind the SSRS Report. With Power BI being able to be launched in an iframe in our ASP.Net app, we really need a means to pass parameters to the Power BI Model which can be used in the query behind (primarily Direct Query) so that the SQL Query will return only the results based on the parameters. The current option of passing Filter Options to the already populated Power BI is not sufficient in terms of both performance and user based security.

[slarkin]

I frequently have to explain to our users why if Power BI Report Server is built on the SSRS engine they cannot pass parameters to a report to dynamically fetch new data sets. I don't have a good answer for them, other than "that's what Microsoft created." Why is this such a hard feature to add? It should work just like it does on the SSRS reports hosted on that web portal. Signed, A Frustrated Business Analyst

[pratik_thanki]

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

[pratik_thanki]

There is a lot of duplication of Posts for this - I really hope we do see this idea in the future, in the meantime this Idea (20367082) should be seen as the main one spearheading this! Duplicates below; https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/10840230-parameters https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/35874259-allow-for-passing-parameters-like-date-via-slice https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/34885171-please-pass-value-to-stored-procedure-using-slicer https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/31655341-stored-procedure-call-with-parameters-passed-from

[RiccardoDP]

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

[twiegelman]

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

[twiegelman]

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