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
StefanoGrimaldi
Resident Rockstar
Resident Rockstar

Looping with delay timmer between apis call not working

guys Im trying to insert a function between interactions to this code segment; called wait seconds but it doesnt seem to make the wait actually work, any insigt?: 

iterar = List.Accumulate({0 .. numeroIteraciones - 1}, facturas, (state, current) =>
let
id = current * tamanoLote,
headers = [authorization="XXXXXXXXX", accept="application/json"],
facturasObtenidas = ObtenerFacturas(id, headers),
_= Wait_Seconds(20, () => null),
facturasConcatenadas = state & facturasObtenidas
in
facturasConcatenadas
),

 

wait seconds function code: 

//Function to create a timer between interations
let
Wait = (seconds as number, action as function) =>
if (List.Count(List.Generate(() => DateTimeZone.LocalNow() + #duration(0,0,0,seconds), (x) => DateTimeZone.LocalNow() < x, (x) => x)) = 0)
then null else action()
in
Wait





Did I answer your question? Mark my post as a solution! / Did it help? Give some Kudos!

Proud to be a Super User!




1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

3 REPLIES 3
lbendlin
Super User
Super User

That's not how you do delays in Power Query. Use Function.InvokeAfter - PowerQuery M | Microsoft Learn

would appreciate a example of how you would insert the function in the code I pass please @lbendlin 





Did I answer your question? Mark my post as a solution! / Did it help? Give some Kudos!

Proud to be a Super User!




ohh thanks , didnt know of this function will give it a try and come back thanks. 





Did I answer your question? Mark my post as a solution! / Did it help? Give some Kudos!

Proud to be a Super User!




Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

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.