Refresh Failed - SharePoint Invalid Credentials Issue

[MS1821]

Hi all,

Scheduled refresh has been failing for a few of my reports all of a sudden (for about a week now).

I originally had an issue with Power Bi Desktop, but I turned off Parallel loading of tables and now the Desktop Loads/refreshes  fine.  The webservice i get these errors, any guidance where to start?

{"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 SharePoint source are invalid. (Source at SHAREPOINTFILE_xlsx/_api/contextinfo.)"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.CredentialError.DataSourceKind","detail":{"type":1,"value":"SharePoint"}},{"code":"Microsoft.Data.Mashup.CredentialError.DataSourcePath","detail":{"type":1,"value":"SHAREPOINTFILE_xlsx/_api/contextinfo}},{"code":"Microsoft.Data.Mashup.CredentialError.Reason","detail":{"type":1,"value":"AccessUnauthorized"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.DataSources","detail":{"type":1,"value":"[{\"kind\":\"SharePoint\",\"path\":\"SHAREPOINTFILE_xlsx/_api/contextinfo\"}]"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.Reason","detail":{"type":1,"value":"AccessUnauthorized"}}],"exceptionCulprit":1}}} Table: Invoice Amount Unique.

I have access and correct creditails for all my web/sharepoint links. All are online under Manage Connections and Gateways.

Thanks,
Matt 

[v-bofeng-msft]

Hi @MS1821 ,

The error message indicates there might be an issue with authentication or permissions when attempting to connect.

If I may suggest, here are some steps that could assist in troubleshooting and potentially resolving the issue:

1\Kindly navigate to Power BI Service > Your Workspace > Your Semantic Model > Settings > Data Source Credentials, and verify whether the credentials for SharePoint remain valid.

2\In the Gateway and Cloud Connections section, would you mind confirming that the SharePoint connection is properly configured and that its status is "Online"?

Best Regards,

Bof

[MS1821]

Data Source Credentials are valid and the status is Online.