Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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 w...
Show and Tell
GilbertQ's avatar
GilbertQ
Super User
3 years ago

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?

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.

     

     

    Thanks in advance!