Forum Discussion

vijeth_sankethi's avatar
vijeth_sankethi
Frequent Visitor
8 years ago

Execute stored procedure with user parameters

Hi All,    I am still trying to learn the nuances of Power BI as I am from a SSRS background.    I am trying to achieve the following in Power BI.  The user should have an option to select a dat...
Need Help
pthapa's avatar
pthapa
Post Patron
2 years ago

I had similar issues on my SSRS reports that I am migrating to PBI. Becasue pretty much all the stored procedures have the parameters on them which makes it hareder for us to run the stored procedure in PBI with parameters. 

My suggestion to all is try to rewrite the stored procedure without the parameter, that would work better in this scenario. Parameters are meant to work as a filter in SSRS to retrieve the data from the database, however in power bi slicer will do the job. But, if you need to limit the data extract in PBI, apply some filter on date field in Stored Procedure at the first approach, that would help.

Thanks,

Pthapa