The credentials provided for the SQL source are invalid

AndySugs — Thu, 14 Sep 2023 11:24:14 GMT

Hi,

Last week an automatic refresh on a Power BI Data Model suddenly started failing. The Manager of the Team has left and on day before it failed her windows account was put into quarantine so I thought that may be the issue. However, we restored her account yesterday but today the refresh is still failing.

This is the error that the refresh is showing:

There was an error when processing the data in the dataset.

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 ########;Daily_Sales_RR.)"}},{"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":"########;Daily_Sales_RR"}},{"code":"Microsoft.Data.Mashup.CredentialError.Reason","detail":{"type":1,"value":"AccessUnauthorized"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.DataSources","detail":{"type":1,"value":"[{\"kind\":\"SQL\",\"path\":\"########;Daily_Sales_RR\"}]"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.Reason","detail":{"type":1,"value":"AccessUnauthorized"}}],"exceptionCulprit":1}}} Table: DailySales_Daily.

Cluster URI: WABI-NORTH-EUROPE-K-PRIMARY-redirect.analysis.windows.net

Activity ID: 87dc2ba2-c6e8-4af6-b218-de7e0de8f116

Request ID: 27b576a7-e7a8-b928-8faa-44a459ca8796

Time: 2023-09-14 08:54:22Z

Any help would be greatly appreciated as this has been going on for a week now.

Re: The credentials provided for the SQL source are invalid

lbendlin — Sat, 16 Sep 2023 21:49:35 GMT

1. Go to the gateway management page and update the connection credentials

2. Go to the workspace and take over the dataset

3. Reconfigure the gateway connection for the dataset

4. update the credentials for the dataset (optional)

Then re-enable the schedule (if it was suspended) and test a refresh.

Re: The credentials provided for the SQL source are invalid

Anonymous — Thu, 06 Jun 2024 13:31:40 GMT

Hello ,

This solution has not worked in our case

Re: The credentials provided for the SQL source are invalid

lbendlin — Thu, 06 Jun 2024 13:37:13 GMT

would you like to provide some more details?

topic Re: The credentials provided for the SQL source are invalid in Report Server

The credentials provided for the SQL source are invalid

Re: The credentials provided for the SQL source are invalid

Re: The credentials provided for the SQL source are invalid

Re: The credentials provided for the SQL source are invalid