Latest Enterprise DNA Initiatives


Refresh Failed due to Gateway Invalid Connection Credentials Error

Hi, I am having issues with the data refresh failing in the Power BI service. The error reads:

“Data source error: {“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”:“The credentials provided for the SQL source are invalid. (Source at okr-bne-sql01\okr;OKR_REPORTS.)”}},{“code”:“DM_ErrorDetailNameCode_UnderlyingHResult”,“detail”:{“type”:1,“value”:"-2147467259"}},{“code”:“Microsoft.Data.Mashup.CredentialError.DataSourceKind”,“detail”:{“type”:1,“value”:“SQL”}},{“code”:“Microsoft.Data.Mashup.CredentialError.DataSourcePath”,“detail”:{“type”:1,“value”:“OKR-BNE-SQL01\OKR;OKR_REPORTS”}},{“code”:“Microsoft.Data.Mashup.CredentialError.Reason”,“detail”:{“type”:1,“value”:“AccessUnauthorized”}},{“code”:“Microsoft.Data.Mashup.MashupSecurityException.DataSources”,“detail”:{“type”:1,“value”:"[{“kind”:“SQL”,“path”:“OKR-BNE-SQL01\OKR;OKR_REPORTS”}]"}},{“code”:“Microsoft.Data.Mashup.MashupSecurityException.Reason”,“detail”:{“type”:1,“value”:“AccessUnauthorized”}}],“exceptionCulprit”:1}}} Table: C2W Client Offer. Cluster URI:WABI-AUSTRALIA-EAST-A-PRIMARY-redirect.analysis.windows.net Activity ID: c6af95ec-c6a7-4aed-ac39-348682e0ca1a Request ID: d99ed5ba-f539-a61a-e530-ed737a34d771 Time: 2022-08-14 23:21:23Z”

The on-premises data gateway uses the default service account and the password has expired, as seen in the command prompt screenshot:

If I reset the service account password and log in again, do I still need to re-configure the gateway settings in Power BI service or it would automatically update? Or is this related to service password expiration or we need to provide a different account for the gateway?

Thank you! Would really appreciate all your inputs and suggestions!

Bumping this post

Hi @baymaxx! We noticed that your inquiry was left unsolved for quite some time now.

Looks like your inquiry was out of the experts and users’ bounds.

We strive to answer ALL inquiries in the forum. However, if you are sure that you provided all pertinent context to your concerns and read how to use the forum more effectively and still find your question unanswered, you can check out tutorials to learn this yourself as your membership also comes with relevant resources that may help you with your Power BI education.

While our users and experts do as much as reasonable to help you with your inquiries, not all concerns can be attended to especially if there are some learnings to be done. Thank you!