In relation to PowerBI for desktop, I used the default and later an updated version of MySQL Connector net. I get the following connection error each time.
DataSource.Error: An error happened while reading data from the provider: 'The handshake failed due to an unexpected packet format.'
Details:
DataSourceKind=MySql
Using the same connection settings I can successfully connect via an ODBC connector and also via MySql Workbench. Which leads me to believe that there must be an issue with PowerBI desktop.
The Sql server does not use SSL and I had to disable use of SSL in ODBC and MySql Workbench to get the connection to work. I have tried the same in PowerBI by un-checking "Encrypt Connection" under permissions for the data source. But doing so makes no difference to the error message.
Can anyone advise on how to debug this further? (An option is to use the ODBC connector instead, but that would mean re-writing a lot of queries which have already been setup for MySQL so I would prefer to avoid a work around.)
