Power BI Online: Invalid connection credentials.

[LocNguyen]

Hi,

My PowerBI dataset has been working fine, but one day suddenly refused to refresh because of the error below:

Underlying error code:	-2147467259
Underlying error message:	The credentials provided for the SharePoint source are invalid. (Source at https://xxxx.sharepoint.com/sites/tech.)
DM_ErrorDetailNameCode_UnderlyingHResult:	-2147467259
Microsoft.Data.Mashup.CredentialError.DataSourceKind:	SharePoint
Microsoft.Data.Mashup.CredentialError.DataSourceOriginKind:	SharePoint
Microsoft.Data.Mashup.CredentialError.DataSourceOriginPath:	https://xxxx.sharepoint.com/sites/tech
Microsoft.Data.Mashup.CredentialError.DataSourcePath:	https://xxxx.sharepoint.com/sites/tech
Microsoft.Data.Mashup.CredentialError.Reason:	AccessUnauthorized
Microsoft.Data.Mashup.MashupSecurityException.DataSources:	[{"kind":"SharePoint","path":"https://xxxx.sharepoint.com/sites/tech"}]
Microsoft.Data.Mashup.MashupSecurityException.Reason:	AccessUnauthorized
Cluster URI:	WABI-WEST-US-redirect.analysis.windows.net
Activity ID:	08b21062-364a-4ddf-b58a-faf39fbfb24a
Request ID:	803bee75-fa6a-4efb-886c-e5d937936a11
Time:	2023-02-19 03:37:01Z

I can use the same credentials to refresh the same dataset on Power BI Desktop without any issue. This datasource is on my company cloud so does not need a gateway.

The datasource credential section is green and having no error. I'm using authentication method OAutho2, and privacy level as Organizational:

My desktop version is updated. This is a sharepoint folder containing a bunch of excel files, and they were all refreshing fine before. My sharepoint login security is admin, so I should have full access. I tried opening that folder on my sharepoint and was able to view/edit it without any problems.

Does anyone get this error before? Appreciate all your helps!

Best,