Displaying current iteration of a loop for debugging purposes

Hi there,

I have a query that calls a third party API. It loops through ~200k worth of requests (IP addresses being the main parameter), and the transforms the results. In smaller batches (~50k), the query runs fine. However in the large batch it never finishes, despite it running for hours. I've talked to the third party vendor and they tell me it is not a limiation on their end.

Therefore what i would like to do is see where in the request queue, my loop in up to. Ideally I would like to display the current iteration of the loop somewhere within PowerBI, possible via a MsgBox.

Is something like this possible?

My backup plan is to do something manual like writing the IP being processed to a text file every x number of iterations, but I was wondering if there was a 'best practice' methodology here?

Thanks

Chris