Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.

Reply
StackyWompus
New Member

Make an API call for each item in a list, combine results into a single table

Hi everyone. I'm still pretty new, so this may be a stupid question, or I'm approaching it the wrong way. I've created an API function called GetTableData that takes in a single ID as a parameter, makes the call, and returns the table. Is it possible to take a list of IDs and do a sort of "for each" calling the API function for each ID in the list, combining their results into a single table?

1 ACCEPTED SOLUTION
Kannan_n
Advocate I
Advocate I

Hi @StackyWompus 

This is not a Stupid question, It's an excellent question

 

To perform the operation the steps are a little complicated. I got an Article in Google. i have attached with this follow the steps you can solve your problem.

Article link

 

 

If the answer is Happy Give a Like & are you satisfied with the Answer Make the question Resolved 

Thanks/Regards 

Kannan.N

View solution in original post

2 REPLIES 2
Kannan_n
Advocate I
Advocate I

Hi @StackyWompus 

This is not a Stupid question, It's an excellent question

 

To perform the operation the steps are a little complicated. I got an Article in Google. i have attached with this follow the steps you can solve your problem.

Article link

 

 

If the answer is Happy Give a Like & are you satisfied with the Answer Make the question Resolved 

Thanks/Regards 

Kannan.N

Exactly what I needed! Thank you so much for the quick fix. That was a very helpful resource, made perfect sense.

Helpful resources

Announcements
October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Kudoed Authors