on 24 Nov 2015 11:59:59
Execute stored procedure parameters
- Comments (15)
RE: Parameters
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
RE: Parameters
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.
RE: Parameters
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.
Thanks
nathan
RE: Parameters
This is badly needed for handling reports with large volumes of data. I've had to decrease report efficiency just to use Power BI.
RE: Parameters
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.
RE: Parameters
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
RE: Parameters
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
RE: Parameters
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
RE: Parameters
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.
RE: Parameters
Agree with RafalK ;"It would also be great to pass the parameter to an sql in Power BI"