Gateway Refresh Time out

[nagaraj]

Hi,

 I have some interesting scenario mentioned below, please help with any inputs

I have a scheduled gateway and runs every day. 

Some times its Success and most of the times data refresh getting failed.

And everytime i see the same issue (TIMEOUT).

After the refresh gets failed if i try to rerun manually everytime this gets succeed, not sure of this behaviour.

Regards
nagaraj

[v-juanli-msft]

Hi @nagaraj 

Thanks to amitchandak, articles you shared are very helpful.

Besides, please check if there are many dataset refreshing at this time and whether the dataset is too big.

Please adjust the refresh time for many datasets to a different time period, or use incremental refresh which will improve performance.

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[nagaraj]

HI @v-juanli-msft 

 Thanks for the suggestions, actually we are at present having incremental refresh and i tried changing the Refresh times as well but no luck. 

Actually my source database is an Azure SQL DB, not sure if there is any issue with Azure SQL DB or any limtiation with that.

[amitchandak]

@nagaraj , refer if these can help

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem-tshoot

https://guyinacube.com/2016/09/21/troubleshooting-connectivity-tips/