Forum Discussion
Anonymous
6 years agoNot applicable
Scheduled Refresh Fails Intermittantly
We have an issue with scheduled refreshes not working occasionally. This is ocurring with two different on-premise data gateways that connect to two different SQL Servers and databases which are par...
ibarrau
6 years agoSuper User
If the error is in 20-30 seconds is a connection problem. The gateway is having trouble to connect to the data source. Please be sure you have the gateway output ports opened and to test a connection from the gateway administration and from the gateway computer to garantee you can actually connect the data.
Regards,
Anonymous
6 years agoNot applicable
Thanks, but have run the gateway port test. All came back fine. I have additional logging turned on as well. Unfortunately it the gateway logs show the same information as the Power BI "Refresh History" modal. There is no rhyme or reason to the failures and am thinking at this point it is something at the network layer or an AV monitor/scanner on the server blocking communication out.