Showing results for 
Search instead for 
Did you mean: 

Power BI web api sending get requests repeatedly

I'm trying to get data from an external source into powerBI using an API. 

Since the amount of data is big (~ 800000- 900000 records) the API takes about a minute to respod but powerBI keeps sending the same get request again and again till it brings down the server. 


Is there a setting that we can change on the gateway to prevent requests shorter than the timeout it'll reduce the load on the API server.
Status: New
Community Support

Hi @rpai27 ,

As far as I know, currently there is no settings about this feature in gateway to change it. We can set the timeout time manually in power query like this:

Web.Contents("URL", [Timeout=#duration(0,0,15,0)])



You can sumbit an idea here about this feature and vote for it:


Best Regards,
Community Support Team _ Yingjie Li

Frequent Visitor

I already have the timeout defined. But Powerbi still sends out the same request repeatedly. 😞 

If the payload is big it can potentially bring down the API server. 


I'll submit a idea ticket.  Thanks