SQL connector error: 'Binding protocol error due to unexpected package format.'

[Anonymous]

Hello everyone -- wondering if you could help? I'm trying to connect to MYSQL and get the following error -

Details: "An error occurred while reading provider data: 'Handshake failed due to an unexpected package format.'"

I can connect through Workbench, but I can't figure out why I can't connect via PBI.

Any ideas?

Thank you!

[Anonymous]

Thank you all for your help - updated connector and desktop to the latest versions and it's now working!  

[v-xicai · Accepted solution]

Hi @Anonymous ,

You may connect to the MySQL data using  MySQL database connector, see the detail: Connect Power BI with MySQL Database.

Follow the steps, there may be a warning "The connector requires one or more additional components to be installed before it can be used." In this Case - Click Learn More link and it will direct to MySQL connector for the .net page: https://dev.mysql.com/downloads/connector/net/. Install this and restart the computer. 

Best Regards,

Amy 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thanks for your reply Amy, @v-xicai 

I have installed the connector - although it is the 32bit - we have the 64bit PBI - does that matter? There doesn't seem to be an option for the 64bit connector. 

Any other ideas? 

thank you again!

[v-xicai]

Hi @Anonymous ,

The 32-bit connector is enough, and you can use it with 64-bit Desktop. Please follow the steps in link Connect Power BI with MySQL Database.

If you still have this issue for Power BI, you'd better create a support ticket in Power BI Support , Scroll down and click "CREATE SUPPORT TICKET", to get further help.

Best Regards,

Amy 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

thank you - i have installed the connector and have the latest version - i can connect to the db via workbench but can't get the connection up and running through PBI. 

Any other ideas? 🙂

[amitchandak]

@Anonymous , Make sure you have the correct connector :

https://community.powerbi.com/t5/Power-Query/Trying-to-connect-to-MY-SQL-from-Power-BI/td-p/195060