Solved: MySQL connection error for standard gateway

Abrar786 · ‎05-31-2023

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.

Thank you.

Greg_Deckler · ‎05-31-2023

@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

Abrar786 · ‎05-31-2023

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 · ‎05-31-2023

@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...