Forum Discussion
Execute stored procedure with user parameters
Solution SageWhy not bring in all the data associate with a Data Table and then just use filters to control what is displayed? I use PowerBI with hundreds of thousdans of records.
Hey vijeth_sankethi
If you are using DirectQuery, you can achieve this by running SQL code in an R visual. It's quite the workaround but works great. Check out my video here if you're interested:
https://www.youtube.com/watch?v=3QiTBXfxzHA
Hope this helps,
Parker
Hi Anonymous,
This is the closest to the solution I have been searching for. Thank you..
But Instead of the Drill down player, Can we use something like a Date picker / Text box which is used by the user and based on his selection, that date value would be passed to a Stored Procedure and results are shown in a table?
Apologies if the question is basic but I can't seem to get it working.
Thanks,
Vijeth
Yep! Any selection you make on any slicer or visual will re-run the r script and execute the stored procedure. I just used the drill-down player to make it automated
v-piga-msftResident Rockstar
Hi vijeth_sankethi,
Have you solved your problem?
If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please feel free to ask.
Best Regards,
Cherry
Hi v-piga-msft,
Unfortunately, I was not able to get the solution in the way I wanted. I had tried Anonymous solution but it didn't work the way I expected. It is maybe because I am a newbie in Power BI and couldn't get it to work. I can give more details if you need. So I didn't mark it as a solution.
Thanks,
Vijeth
