Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi Power BI,
I have been having this issue for quite some time now and have seen lots of other people with the same problem, but apparently no resolution: https://community.powerbi.com/t5/Desktop/DataSource-Error-MySQL-Host-is-blocked-because-of-many/m-p/.... The issue is that some connections won't refresh and the following error occurs.
DataSource.Error: MySQL: Host 'xxx.xx.xxx.xx' is blocked because of many connection errors; unblock with 'mysqladminflush-hosts'
It is temporarily fixed by refreshing the dataset, but many users (myself included) seem to be getting the issue again every few days, and having to ask the sys admins to flush hosts every time.
Is there anything that can be done about this issue?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.