Forum Discussion
Run stored procedure in a loop
Thanks, I also found this solution https://www.youtube.com/watch?v=iiNDq2VrZPY
In my case this is a better solution. However I notice something strange. Looks like the data which is in all the "data tables" is not loaded. Seems like I first need to open a table before the data gets loaded. Still try to figure this out.
Hi sp_mike,
In your scenario, you said that you want to run stored peocedure in a loop, did you mean that you want to get multiple records at a time instead of getting one record at each time, right? If so, you could try to modify you stored procedure , then pass multiple parameters like "p1,p2,p3" in powerbi , then you should get records of p1,p2p3 from stored procedure.
You could refer to How to pass multi-value parameters to a Stored Procedure datasource for details.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks, I also found this solution https://www.youtube.com/watch?v=iiNDq2VrZPY
In my case this is a better solution. However I notice something strange. Looks like the data which is in all the "data tables" is not loaded. Seems like I first need to open a table before the data gets loaded. Still try to figure this out.
Got it, I forgot to select the columns from the Stored pocedure (as explained in the video).