Reply
AndySugs
Regular Visitor

The credentials provided for the SQL source are invalid

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.  

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

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.

 

View solution in original post

3 REPLIES 3
lbendlin
Super User
Super User

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.

 

Hello ,

This solution has not worked in our case

would you like to provide some more details?

 

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)