Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Anonymous
Not applicable

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

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!

1 ACCEPTED SOLUTION
v-xicai
Community Support
Community Support

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.

View solution in original post

6 REPLIES 6
Anonymous
Not applicable

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

v-xicai
Community Support
Community Support

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
Not applicable

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!

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
Not applicable

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
Super User
Super User

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.