Forum Discussion
dpombal
Post Partisan
Post PartisanData Gateway Timeout on data refresh MySQL
I have a local MySQL instance and a report with 5 ,1 of them 7 million rows. I had errors based on MySQL timeouts, since data refresh takes 25 and 40 minutes. However now I am getting a timeout ...
GilbertQ
Super User
Super UserHi dpombal
When you refresh the PBIX file in Power BI Desktop does it refresh successfully?
If it does then at least you know that the issue is with the Gateway and possibly changing the setting below to 60 might solve your issue.
I would suggest making a backup of the config file before making any changes. As well as restarting the service once you have made your changes.
dpombalPost Partisan
Post PartisanWhen I refresh in Desktop, it refreshes successfully.
I changed value 20 to 80 and restart service but it is still failing, not sure if it is caching.... or what is happening
- GilbertQI'm not sure why it is happening. I have personally never tried it myself. I might try it early next week on a test VM
- dpombal
thanks I am also waiting for tech support reply, thanks for your help
v-chuncz-msftCommunity Support
Try to specify Timeout parameter in Advanced Editor as well.