cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Abrar786
Helper I
Helper I

MySQL connection error for standard gateway

Hello,

 

I am trying to establish a connection with MySQL and encountering the following error when attempting to connect from Power BI Services. However, when I connect from Power BI Desktop, it works fine. After uploading the .pbix file to the workspace, I am unable to establish a connection. I am using the standard version of the gateway. MySQL connector is already installed on gateway machine.

 

Abrar786_0-1685535948069.png

Thank you.

 

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

@Abrar786 From the error message, you either do not have the MySQL connector installed or the incorrect version of the MSQL connector: (1) Solved: Power BI Desktop - Unable to Connect - Microsoft Fabric Community


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

2 REPLIES 2
Abrar786
Helper I
Helper I

Hi @Greg_Deckler ,

Thank you for your response. Earlier, I had installed MySQL 8.0.33, but now I have installed version 8.0.1, and it works fine.

Greg_Deckler
Super User
Super User

@Abrar786 From the error message, you either do not have the MySQL connector installed or the incorrect version of the MSQL connector: (1) Solved: Power BI Desktop - Unable to Connect - Microsoft Fabric Community


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors
Top Kudoed Authors