Forum Discussion
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...
Hi vijeth_sankethi ,
I am wondering if there has already been a solution for this? I am also facing the same problem as I am moving all my SSRS reports to Power BI. I am also a newbie at PowerBI so a solution would be greatly appreciated. Thanks!
Hi Anonymous ,
Unfortunately, I wasn't able to get that working in the way I expected. So Instead, I executed the Stored Procedure for all possible Input values and stored the results in a table. This table was then used to populate the Power BI report. Sorry for not being to help you.
P.S. I wrote another job which calls the SP to populate the base table. This job runs daily and since my source is a Data warehouse which is populated daily, it worked out in the end.
Thanks,
Vijeth