Forum Discussion

dpombal's avatar
dpombal
Icon for Post Partisan rankPost Partisan
9 years ago

Data 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 ...
Need Help
GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
9 years ago

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

  • dpombal's avatar
    dpombal
    Icon for Post Partisan rankPost Partisan
    9 years ago

    When 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

    • GilbertQ's avatar
      GilbertQ
      Icon for Super User rankSuper User
      9 years ago
      I'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's avatar
        dpombal
        Icon for Post Partisan rankPost Partisan
        9 years ago

        thanks I am also waiting for tech support reply, thanks for your help