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

[kiranvuppala]

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

[v-shex-msft]

Hi @kiranvuppala,

>>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 ??

Current power bi mysql connector not support to use plugins. Perhaps you can post your requirement to ideas.

Regards,

Xiaoxin Sheng

[kiranvuppala]

Thanks Sheng. Do you have any link where i can make share this requirement ?

[v-shex-msft]

Hi @kiranvuppala,

You can post your requirement to below link:

Power bi Ideas

Regards,

Xiaoxin Sheng

[kiranvuppala]

Sure. Thanks

[kiranvuppala]

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