Timeout error on gateway refresh, MySQL database

[RDKleinJan]

Hello, I've been working on a new dataset recently that dives deeper into the data of our application, the dashboards are also ready.

The only thing that I'm running into at the moment is the automated refresh.

Inside PowerBI Desktop, the refresh runs fine. The file is about 260MB.

When I publish the dataset to the service and connect it to the gateway however, the refresh fails every time. 

PowerBI throws some kind of timeout error; "TThe XML for Analysis request timed out before it was completed. Timeout value 7200 sec."

I have tried to adjust the source in Desktop with a command timeout of 120 minutes, but after publishing  in the service and attempting a refresh it gave no juice.

I'm wondering on what end i should try to troubleshoot next, is it on the end of the database? Or should I try to change some configs in the gateway settings?

Thanks for reading 🙂

[GilbertQ]

Hi @RDKleinJan 

The timeouts will be done on the Data Source Connection.

There is an overall timeout of 2hours for all dataset refreshes. So you would need to find a way to get the data in quicker than 2 hours if no incremental refreshing.

[GilbertQ]

Hi @RDKleinJan 

That would appear to be on your data source connection. It times out after 2 hours.

This might have to be with your gateway if the connection between your gateway and the data source is slow. Also if your gateway server has slow bandwidth that could also be an issue.

What you could look into is configuring Incremental refreshing which would then load the data incrementally. I would suggest creating monthly partitions so it will load the data in monthly portions instead of it all together.

[RDKleinJan]

Hi Gilbert, thank you for your reply!

I will look into incrementally refreshing the dataset. I am however unsure if it's a viable solution, seeing as I am dealing with a "living" database, where tens of thousands of rows change each day.  But I will try and see what sticks 🙂

Do you happen to know if there is any way to increase the timeout value on the gateway's end, maybe inside of a config file somewhere?

Thank you for your help