Problem with Power Query in Excel 2016 RRS feed

  • Question

  • Hi there!

    When I moved to Excel 2016, I start getting such error.

    "MySQL: Host 'X.X.X.X' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'."

    Why Power Query is bombing MySQL with unnecesary number of connectrions?

    -- Paul

    Friday, October 2, 2015 1:29 PM


All replies

  • I have had some issues with Power Query in Excel 2016 as well, specifically the a connection to Microsoft CRM, doesn't work in 2016 but works fine in 2013.
    Friday, October 2, 2015 2:25 PM
  • Actually I found solution by accident.

    PQ automaticaly turns on Secure Connection flag.

    If I clear this flag, # of connections is moderate and MySQL does not block them.

    -- Paul

    Saturday, October 3, 2015 8:41 PM