Forum Discussion
DataSource.Error: MySQL: Host is blocked because of many connection errors
I'm having the same exact problem. The connection starts working again after I ask the admins to flush the hosts, but now it's happening once every few days (I'm sure the credentials are correct). I'll have them check out the logs, but maybe there is something on the Power BI side that I could do?
Hi Sarunaskas,
Did you manage to resolve this at all?
I'm connecting to hosted MySQL through Power BI desktop which works perfect, but publishing to Power BI on a scheduled refresh is nothing but a nightmare at the moment - having the same issue as below.
Thanks
Hi!
I asked the sys admins to increase the MySQL server connection threshold, so didn't have any problems ever since.
Make sure you have plenty of RAM and a powerful CPU on the server that has Enterprise gateway running. After I monitored resource usage, it was apparent that it was struggling with RAM, so that could be an option you could check.Hi,
Thanks for the prompt response!
Ah right. I have Enterprice Gateway running on a virtual machine sat on our main server, the virtual machine has 8GB RAM (showing 6GB available) and is always online.
Just to check, I need the enterprise gateway to connect to:
* hosted MySQL on VPS (data pulled from multiple CRM sources)
* on-premise SQL (Sage 200 Manufacturing)
Like I say, I can connect to both sources no issues, just getting the refresh online connecting through the web seems to be the issue.
Help appreciated in advance
So what error message, exactly, are you receiving?