topic Re: MySQL Connection in Report Server

MySQL Connection

moe_elbohsaly — Thu, 29 Sep 2022 13:29:08 GMT

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?

Re: MySQL Connection

v-henryk-mstf — Fri, 30 Sep 2022 03:18:01 GMT

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.

Re: MySQL Connection

moe_elbohsaly — Fri, 30 Sep 2022 07:30:02 GMT

Error codeDMTS_DatasourceHasNoCredentialError

Data source errorDatasource has no credentials

Cluster URI https://api.powerbi.com

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)

Re: MySQL Connection

moe_elbohsaly — Fri, 30 Sep 2022 07:49:26 GMT

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.