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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
moe_elbohsaly
Helper I
Helper I

MySQL Connection

After gaining access to my newly formatted desktop PC, I downloaded again Power BI, MySQL connector 8.0.16, and an on-premise gateway. Upon connecting to my data hub, I encounter this

 

Failed to update data source credentials: MySQL: Unable to connect to any of the specified MySQL hosts.

Activity ID:3263caea-14ad-48b2-95ea-2fc5657559b0
Request ID:86eebf39-3655-dddd-8e23-e339c30d8e01
Status code:400
Time:Thu Sep 29 2022 16:22:08 GMT+0300 (Eastern European Summer Time)
Service version:13.0.19134.41
Client version:2209.3.13354-train
Cluster URI:https://wabi-west-europe-redirect.analysis.windows.net/

 

May you advise?

1 ACCEPTED SOLUTION
v-henryk-mstf
Community Support
Community Support

Hi @moe_elbohsaly ,

 

Based on the error message prompt, it was able to rule out that it was not the connector version.

 

Also, try deleting the credential information in the data source setting and try again.

vhenrykmstf_0-1664507630741.png


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.

View solution in original post

3 REPLIES 3
moe_elbohsaly
Helper I
Helper I

I have tried to setup the gateway on a previous laptop I had and it worked! I don't know why these errors emerge once I do the same setup on the desktop.

moe_elbohsaly
Helper I
Helper I

Error codeDMTS_DatasourceHasNoCredentialError
Data source errorDatasource has no credentials
Activity Idd528493e-c3ea-47ff-b420-ac7782a77178
Request Id6d7edd46-7617-436e-868b-b93eedab0c84
TimeFri Sep 30 2022 10:26:10 GMT+0300 (Eastern European Summer Time)
v-henryk-mstf
Community Support
Community Support

Hi @moe_elbohsaly ,

 

Based on the error message prompt, it was able to rule out that it was not the connector version.

 

Also, try deleting the credential information in the data source setting and try again.

vhenrykmstf_0-1664507630741.png


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.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

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

Top Solution Authors