Forum Discussion

gman's avatar
gman
Frequent Visitor
10 years ago

mySQL connections staying open or failing

Hi,   I keep getting many connectoins error and being locked out and needing to flush hosts when accesssing my mySQL server and it looks like PowerBI is leaving connections open or accruing a bunch...
Drshoe28's avatar
Drshoe28
New Member
9 years ago

I'm experiencing the same exact thing. Anyone find a solution?

  • viera00's avatar
    viera00
    Icon for Helper II rankHelper II
    9 years ago

    Hi,

     

    I uninstalled the "enterprise gateway" and replaced it with the "Persona Gateway".

     

    Now the refresh works fine. It seams (just my hipothesis) that the enterprise gateway closes connections incorrectly, and the personal dont.

     

    It is worth to try.

     

    Let me know if you have success with this option.

     

    Regards,

     

    GV