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

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
Anonymous
Not applicable

Invalid connection credentials for MYSQL database

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 enterprise gateway. MySQL connector is already installed on gateway machine.

 

Ynr0225_0-1687458663197.png

Thanks in advance!

3 REPLIES 3
GilbertQ
Super User
Super User

Hi @Anonymous 

 

It would appear that you are having an authentication error possibly on your mySQL side, I would suggest chatting to the DBA to see if the query is making it to the database?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

GilbertQ
Super User
Super User

Hi @Anonymous 

 

When the error is an SSPI error that is typically a connection error from your enterprise gateway to your MySql database. 

 

Could you try and open the PBIX on your gateway server and refresh and see if that works?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Anonymous
Not applicable

Hi @GilbertQ ,

I opened the Pbix file in gateway server and refreshed the report but getting same error in Power BI desktop as shown in below screenshot. Can you please let us know what should be done in order to troubleshoot the issue while creating gateway connection for MYSQL.

 

Ynr0225_1-1687523115774.png

 

Thanks in advance!

 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Kudoed Authors