Forum Discussion
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? |
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.
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.
3 Replies
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.
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.- Error codeDMTS_DatasourceHasNoCredentialErrorData source errorDatasource has no credentialsCluster URI https://api.powerbi.comActivity Idd528493e-c3ea-47ff-b420-ac7782a77178Request Id6d7edd46-7617-436e-868b-b93eedab0c84TimeFri Sep 30 2022 10:26:10 GMT+0300 (Eastern European Summer Time)
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.
