Forum Discussion
Run stored procedure in a loop
I get some data from a table, let say salesorders.
Each salesorder has a few orderlines, to get the details from the orderlines I need to run a stored procedure for each line.
I know how to run the stored procedure, allthough not in direct query (which is still not possible?) but I can work around that. But how can I run the stored procedure a few times (for each....)?
Thanks, Mike
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.
3 Replies
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 ZhiIf 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.
