Forum Discussion
Execute stored procedure with user parameters
Why 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
Hi Seward12533,
I can bring all data into the datatable but it is not static. Based on the selected date, the calculations will change. So I can't bring all the data into the datatable in one shot.
Another way is to consider all the dates for the past 2 years, and calculate for each date and insert into a table and bring that table's contents over to the datatable. The amount of data would be huge.
I personally believe that this is not an apt solution. But if nothing works, i will do this itself.
Thanks,
Vijeth
