Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to Solution.
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).
User | Count |
---|---|
70 | |
70 | |
34 | |
23 | |
22 |
User | Count |
---|---|
96 | |
94 | |
50 | |
42 | |
40 |