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.
How to call multiple procedures in sequence or concurrent in Microsoft Fabric Factory
Solved! Go to Solution.
Hi @jlakshminaraya
Thanks for using Fabric Community.
You can achieve the above requirement by using a layout as shown below:
Hope this helps. Please let me know if you have any further queries.
Hey,
The variable has the SP names :
dbo.sp1;dbo,sp2
the split function splist this variable into an array which is iterated over the for each.
And the item() is basically the iteration value so it would be dbo.sp1 or dbo.sp2 which is passed over within the sp activity.
So the SP activity to execute those SPs.
Thanks @NandanHegde for your time and detail explanation.
In step 3, do i need to import all 5 stored procedures inside of "for each" and edit the settings of each procedure?
if yes, stored procedure name on each is SP setting is @item() is final , or something to be enterd?
If No, what is the body of stored procedure you have imported in step?
Thanks,
Lakshmi Narayana
Hey,
The variable has the SP names :
dbo.sp1;dbo,sp2
the split function splist this variable into an array which is iterated over the for each.
And the item() is basically the iteration value so it would be dbo.sp1 or dbo.sp2 which is passed over within the sp activity.
So the SP activity to execute those SPs.
Hey @jlakshminaraya
The details provided by @Anonymous is correct but it is too manual and in case of new additions, you would have to manually add in new activities.
The below design is a meta data driven flow :
1) Create 2 variable like ParallelExecution and Sequentailexecution with semicolon seperated values
wherein values would your SPname1;spname2 etc
2) use 2 foreach activities one for parallel execution and another one for sequential execution with values for thier settings :
value :
similar would be for sequentail foreach as well
hope this helps.
You can even have the variable as type array and directly use in foreach as is if need be
Hi @jlakshminaraya
Thanks for using Fabric Community.
Can you please explain your ask a little bit more? So that I can help you better.
Thanks.
Hi @jlakshminaraya
Are you asking the same here : How to call stored procedures Concurrently and seq... - Microsoft Fabric Community?
Hi @jlakshminaraya
Thanks for using Fabric Community.
You can achieve the above requirement by using a layout as shown below:
Hope this helps. Please let me know if you have any further queries.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Fabric update to learn about new features.
User | Count |
---|---|
35 | |
16 | |
7 | |
6 | |
3 |
User | Count |
---|---|
48 | |
44 | |
14 | |
8 | |
6 |