topic Re: Gateway invalid credential error in Service

Gateway invalid credential error

Abrar786 — Wed, 05 Jul 2023 16:51:15 GMT

Hello,

I am receiving the following error message while performing a refresh in Power BI online (service), but it works fine in the desktop version.

{"error":{"code":"DM_GWPipeline_Gateway_InvalidConnectionCredentials","pbi.error":{"code":"DM_GWPipeline_Gateway_InvalidConnectionCredentials","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"<ccon>The credentials provided for the MySql source are invalid.

Thank you.

Re: Gateway invalid credential error

GilbertQ — Wed, 05 Jul 2023 21:53:29 GMT

Hi Abrar786

From the error it is saying that you have not entered the credentials for your MySql source.

If not done yet, you have to also install and configure a gateway to connect to MySql source.

Re: Gateway invalid credential error

Abrar786 — Thu, 06 Jul 2023 12:39:48 GMT

Hi GilbertQ ,

Everything was configured correctly. It was working fine until now. Suddenly, this error started occurring in the last two days. If I refresh on desktop, it works fine, but in Power BI online, it throws the above-mentioned error. I have already raised a support ticket with Microsoft.

Thank you.

Re: Gateway invalid credential error

GilbertQ — Thu, 06 Jul 2023 22:35:57 GMT

The only other thing I would suggest is that you have got the latest version of PBI desktop installed?

Re: Gateway invalid credential error

Abrar786 — Thu, 06 Jul 2023 23:08:03 GMT

Hi GilbertQ ,

Yes, i have installed the latest version of power bi.

Re: Gateway invalid credential error

markfast — Fri, 07 Jul 2023 14:46:24 GMT

I have the exact same issue. The cloud service refreshes stopped working the night of July 2 after months of uptime. We've tried deleting the cloud data and re-publishing, installing a new gateway, tried a new user credentials to the MySQL db, uploaded a basic report with 1 table from the db, and nothing has resolved this. Literally going insane trying to figure out what changed one night.

Re: Gateway invalid credential error

markfast — Fri, 07 Jul 2023 16:42:27 GMT

I just got it to work! I upgraded the MySQL Connector/NET version from .28 to .32 on the gateway. Restarted the gateway and it refreshed successfully. The current latest release (.33) does not work.

https://downloads.mysql.com/archives/c-net/

Re: Gateway invalid credential error

Abrar786 — Fri, 07 Jul 2023 17:00:34 GMT

Hi markfast ,

Thank you for the update. After upgrading the MySQL Connector/NET version from .28 to .32, it started working.