Execute stored procedure parameters
Hichem ZENOUDA commented
This fonctionality is already supported by Power BI, You can configure the parameter as variable in advanced editor and allow users to modify it quickly
Dan Blake commented
I am surprised this is not available - quickly hit the limits of what power BI can do against large record sets and considering migrating dashboards to SSRS.
this is badly needed as power bi we should be moving forward and not back wards.. hi dev team i know you guys try to bring features every month. not sure why this critical basic requirement is still not in power BI as this has been raised since 2015!! in this forum ..
Also multiple result set to return from SP to handle via power bi .. SSRS legacy has all this but not in power BI!!.. dev team could you seriously look into this.
Lorie obal commented
This is badly needed for handling reports with large volumes of data. I've had to decrease report efficiency just to use Power BI.
Eugene Harvey commented
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.
Riccardo Di Prima commented
I want to pass parametres to a query in Poweb BI. For example
SELECT Anno, Dimensione, SUM(Importo) Importo
GROUP BY Anno, Dimensione
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 commented
Refer to this as the main Idea for this functionality to avoid duplication:
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.
Sune Birk Olsen commented
Agree with RafalK ;"It would also be great to pass the parameter to an sql in Power BI"
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
Gareth Owen commented
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 commented
Crazy this doesn't exist already.
It would also be great to pass the parameter to an sql in Power BI
Jon Collis commented
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.