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 (58)
- Merged Idea (1)
RE: Passing Parameters to Power BI through Stored Procedure
Thanks
RE: Passing Parameters to Power BI through Stored Procedure
I can already find posts from 2017 on the web. All questions about this feature. Namely for "POWER BI Desktop".
All this is already possible in the paginated report (Report Builder).
And the report builder is ancient.
It's already the year 2023 and there hasn't even been a statement from Microsoft yet.
Maybe we should switch to Tableau Desktop after all?
Because the license we pay you for the reporting service is not small.
What I find annoying is that I now have no solution as to how we can migrate to the cloud.
At the moment it's time to keep looking and hope that I'll find a solution soon. Hardcore would be if I develop the shi... with Access report generator.
RE: Passing Parameters to Power BI through Stored Procedure
RE: Passing Parameters to Power BI through Stored Procedure
It's absolutely ridiculous this feature isn't included yet. I work in an enterprise environment that has used parameterized stored procedures in SSRS reports for more than a decade. Recently we were asked to convert SSRS reports over to Power BI, which should have been a simple process. However, the lack of SP and parameter support has left us trying to "hack" a solution so our (very, very basic) reports can be converted.
I'm going to be suggesting we use something else instead of Power BI, or that we just go back to SSRS. And this is obviously a feature that has been requested since Power BI was launched. Why in the world would such an obvious and expected feature not be included??? I would never have imagined MS would release a reporting tool that is missing the most basic functionality.
For now, Power BI is useless for us unless we want to go back and completely rewrite every single one of our reports to no longer use Stored Procedures and parameters, which is just not going to happen.
RE: Passing Parameters to Power BI through Stored Procedure
I echo the better stated comments already posted. The underlying data behind a slicer selection should be able to be passed as a parameter to a SQL SPROC call.
RE: Passing Parameters to Power BI through Stored Procedure
Calling stored procedures, with and without parameters, is definitely needed as much of the heavy lifting can be done using SQL Server or other databases to take advantage of what they do best. This ability also needs to include the ability to call AWS RedShift stored procedures, with and without parameters. Currently RedShift requires two (2) SQL statements, one to execute the procedure and one to get the results. Power BI Desktop and Report Builder need to handle those two (2) statements. Even if the statements need to be separated by a semicolon or other character.
RE: Passing Parameters to Power BI through Stored Procedure
Yes it would be great idea to be able to pass a parameter exactly as you can in SSRS - sadly missing in Power BI
Same idea as https://ideas.powerbi.com/ideas/idea/?ideaid=9fce0220-d891-46cf-bcbe-1196466bdec8 - shame these cant be merged?
RE: Passing Parameters to Power BI through Stored Procedure
Recently I had a requirement to do some analysis but need to pass parameters to a stored procedure in SQL server ,I can not believe Power BI does not have this functionality already. We should be able to pass parameters from slicers to queries. Add this as soon as possible. Will have to go back to SSRS to do this for now.