I’m using Power Bi dataflows to connect to APIs. I have two queries refreshing twice a day.
The first uses the Products Endpoint and this runs successfully 99.9% of the time, with this as the query:
each Json.Document(Web.Contents(“https://api.veeqo.com”,[RelativePath=“products?page_size=100”,Query=[page=[Column1]],Headers=[Accept=“application/json”, #“x-api-key”=“xxxx”) etc
However, my second query uses Purchase Orders and I’ve broken it down into smaller page chunks of 50, but I gate a Gateway Timeout more often than not:
each Json.Document(Web.Contents(“https://api.veeqo.com”,[RelativePath=“purchase_orders?page_size=50&state=active”,Query=[page=[Column1]],Headers=[Accept=“application/json”, #“x-api-key”=“xxxx”) etc
Why does one API refresh smoothly and the other not?