Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thank you for the suggestion.   The failure error occurs within 20-30 seconds so the 10 minute timeout should suffice I would think. 

ibarrau's avatar
ibarrau
Super User
6 years ago

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's avatar
    Anonymous
    Not applicable
    6 years ago

    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.