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
ibarrau's avatar
ibarrau
Super User
6 years ago

Hi, can you please try adding a timeout like 120 minutes for each query in edit queries. That is the power bi refresh limit from service. If that much doesn't work then you have a problem because 10 minutes is not so much for big tables. The engine could be busy at that time and work upload the data under 10 minutes.

 

I don't think is a power bi problem it looks like an engine problem getting the query results very slow.

 

Regards,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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.