cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
atrigodaroza
Frequent Visitor

MySQL Authentification Error with On Premises Data Gateway

Hi everybody, 

 

Very frustrating issue and I can't find the same exact issue anywhere else.

I have a MySQL connection which works fine on Desktop, but on PBI Online, when using On premises data gateway it gives me an Authentification Error (code : -2147467259).

The gateway is running well, as we are using it already with Power Automate and Power Apps. But when I try to configure the data source to the gateway, it doesn't recognize my authentification (method : Basic, username + password). 

Am I missing something ?

Thank you for the help!

Antonio

1 ACCEPTED SOLUTION

Hello everyone, 

 

I opened a support ticket and the Microsoft Support Team found a solution to this problem. Here's what we had to do : 

  • On Power BI Desktop :
    • Clear cache and then cleared permission from data source settings.
    • refresh and put all the credentials again
    • Publish it to the service.
  • On the online service :

Online refresh worked fine after that. 

 

Antonio

View solution in original post

9 REPLIES 9
v-henryk-mstf
Community Support
Community Support

Hi @atrigodaroza ,

 

Or you can also try going to File|Options and Settings|Data Source Settings and Edit Data Source. Change the credentials to database credentials instead of Windows credentials, then republish.

vhenrykmstf_1-1654570504471.png


Refer to the following related blog entry:

To Amend, Purpose and Bill – Text Analytics and the US Congress (linkedin.com)

Connecting MySQL to Power BI: A Comprehensive Guide (hevodata.com)


If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


Best Regards,
Henry


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hello, 

Thanks for your answer. 
I already had permissions set to database credentials. 
The error occurs when trying to connect the data source to the gateway. Even when I set "Skip Test Connection", when I force a refresh online this is the error that I have : 

  • Underlying error code: -2147467259
  • Underlying error message: The credentials provided for the MySql source are not valid. 

It seems to be a problem of credentials, but I'm sure I have put the right username/password combination.

Thanks a lot for your help!

All the best, 

Antonio

lbendlin
Super User
Super User

Long standing issue. MySQL and Microsoft blame each other.  We have a dedicated gateway with an ancient version (66.8) solely for MySQL refreshes.

Hi, 

 

Thanks for that answer. So it does work with the ancient version ? Do you know where I can find it ?

Thanks again, 

 

Antonio

There is no version 66.8 in this page...

Send me a private message with your email.

Hello everyone, 

 

I opened a support ticket and the Microsoft Support Team found a solution to this problem. Here's what we had to do : 

  • On Power BI Desktop :
    • Clear cache and then cleared permission from data source settings.
    • refresh and put all the credentials again
    • Publish it to the service.
  • On the online service :

Online refresh worked fine after that. 

 

Antonio

Thank You!

 

After one week of headache, this solution helped!

 

Rocko

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.