Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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).
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
78 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |