MySQL Power BI Online Gateway error cannot connect to mashup data source

I created dataset and report in power bi desktop using mysql database but report is not refreshing online via gateway, resulting in below error: MySQL: Host '##.##.##.##' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts' Tried flushing hosts numerious time. Tried using multiple gateways, personnal and enterprise both. Verified that latest Power BI, Gateway and MySQL connector is installed. Appreciate your help on the issue.

Hi avaiyahardik,

 

From this document, such an error occurs, it means that mysqld has received many connection requests from the given host that were interrupted in the middle. The value of the max_connect_errors system variable determines how many successive interrupted connection requests are permitted.

 

Please first ask the admin to run the mysqladmin flush-hosts command from the MySQL administration shell. If problem persists you could try asking them to increase max_connect_errors system variable.

 

Here is a similar thread for your reference: DataSource.Error: MySQL: Host is blocked because of many connection errors

 

Best regards,
Yuliana Gu