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
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.