Powerquery & Zabbix API - DataSource.Error (500) Internal Server Error when asking for much data

[GoingDigital123]

I am using Powerquery to fetch the data from Zabbix using their API. It works fine when I fetch the data for some days, but as I increase the period and the amount of data surpasses the millions of rows I just get the error below after some time waiting, and the query doesn't return anything.

I am using Web.contents to get the data as follows:

I have added that timeout as you can see above but the error just happens much before 5 minutes have passed. How should I solve this? Are there ways to fetch large amounts of data in power query in parts, without being all at once? Or does this error happen because of connection parameters inherent to zabbix configs.?

Thanks!

[lbendlin]

That timeout doesn't do what you think it does.  Instead, use Function.InvokeAfter - PowerQuery M | Microsoft Docs  to space out your requests and avoid overloading their server.