Sign in
 

none
Problem with Power Query in Excel 2016

 > 

    Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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
    |

Answers

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
    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
    |
  • Question
    Sign in to vote
    1
    Sign in to vote

    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
    |