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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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