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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.