cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
magdarlyn Frequent Visitor
Frequent Visitor

How To Connect Power BI to Hosted MySQL Database

Good day house,

 

Please, I am currently experiencing a challenge with Power BI and will appreciate any help/suggestion I can get.

 

I have a MySQL database which is hosted on Godaddy (cPanel hosting) and want to connect to it using Power BI desktop. I have installed the recommended connector (MySQL Connector/Net 6.6.5 for Microsoft Windows) and attempted the connection with (hostname, IP address, IP address: port etc)but I keep receiving the error below.

 

Has anyone else resolved this? I'll really appreciate your help. Thanks in advance.

 

PowerBI-connection-error.JPG

2 ACCEPTED SOLUTIONS

Accepted Solutions
Moderator v-qiuyu-msft
Moderator

Re: How To Connect Power BI to Hosted MySQL Database

Hi @magdarlyn,

 

Are you able to connect to MySQL with MySQL workbench? Ensure that MySQL workbench is installed in the same machine as Power BI Desktop.

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
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

magdarlyn Frequent Visitor
Frequent Visitor

Re: How To Connect Power BI to Hosted MySQL Database

Thanks, Qiuyun Yu!

 

This solution worked for me. When trying to connect with MySQL Workbench, I realized remote connections had to be enabled on the cPanel hosting. Once done, I was able to connect with Power BI.

 

Thanks again for your assistance.

View solution in original post

4 REPLIES 4
Moderator v-qiuyu-msft
Moderator

Re: How To Connect Power BI to Hosted MySQL Database

Hi @magdarlyn,

 

Are you able to connect to MySQL with MySQL workbench? Ensure that MySQL workbench is installed in the same machine as Power BI Desktop.

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
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

Vicky_Song Established Member
Established Member

Re: How To Connect Power BI to Hosted MySQL Database - Status changed to: Needs Info

 
magdarlyn Frequent Visitor
Frequent Visitor

Re: How To Connect Power BI to Hosted MySQL Database

Thanks, Qiuyun Yu!

 

This solution worked for me. When trying to connect with MySQL Workbench, I realized remote connections had to be enabled on the cPanel hosting. Once done, I was able to connect with Power BI.

 

Thanks again for your assistance.

View solution in original post

Highlighted
Moderator v-qiuyu-msft
Moderator

Re: How To Connect Power BI to Hosted MySQL Database

Hi @magdarlyn,

 

Thanks for your update. I will close this thread as the issue is gone now. Smiley Happy

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 287 members 2,584 guests
Please welcome our newest community members: