Power BI web api sending get requests repeatedly

[rpai27]

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.

[v-yingjl]

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)])

Refer: https://stackoverflow.com/questions/51718344/how-to-set-a-max-run-time-timeout-for-power-query 

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

https://ideas.powerbi.com/ideas/

Best Regards,
Community Support Team _ Yingjie Li

[rpai27]

 @v-yingjl 
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