Power BI Desktop error when connecting to remote MySQL instance ( “mysql_clear_password not support)

Hi,

  i am trying to connect remote mysql instance from power BI getting the below exception.

      “mysql_clear_password not supported by any of the available plugins”

 But i am able to connect to the same instance from my local with other mysql clients. All the other clients allow me to do this by setting "ENABLE_CLEARTEXT_PLUGIN" but anyone know how to enable the same from PowerBI Desktop ??

This is very urgent any help is greatly appreicated.

Thanks,

Kiran