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



Follow on LinkedIn
@ 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!:
Power BI Cookbook Third Edition (Color)

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



Follow on LinkedIn
@ 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!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)
Users online (664)