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.
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:
You can sumbit an idea here about this feature and vote for it:
Best Regards,Community Support Team _ Yingjie Li
@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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.