Forum Discussion
Advocate IPower BI Online: Invalid connection credentials.
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,