Forum Discussion
Power BI Gateway timeout change
You will need to implement your own polling mechanism to see which refreshes are in flight for more than 10 minutes and then you need to issue a cancellation request for these. NOTE: That cancellation request may or may not be honored depending on how far the refresh has already progressed. NOTE2: This is not primarily a gateway related issue.
We do a refresh every 10 minutes 24/7, somehow it fails 1-2 a day. Then we are stuck and need to wait for 2 hours because the cancellation token isn't honored. Even when we are only 20 minutes into the refresh.
Edit: DM_GWPipeline_Gateway_TimeoutError is the error we see in the log.
Edit 2: Normally the models refresh in 60 seconds or less.
Have you considered using Direct Query instead?
The data needs to be pulled from an MySQL database, can we get that using DirectQuery?