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!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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
Proud to be a Super User!
Solved! Go to Solution.
That's not how you do delays in Power Query. Use Function.InvokeAfter - PowerQuery M | Microsoft Learn
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
Proud to be a Super User!
ohh thanks , didnt know of this function will give it a try and come back thanks.
Proud to be a Super User!
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 41 | |
| 38 | |
| 36 | |
| 31 | |
| 28 |
| User | Count |
|---|---|
| 129 | |
| 88 | |
| 79 | |
| 68 | |
| 63 |