Forum Discussion
Gateway Sharepoint Error -2147467259
Hi I'm trying to connect my gateway to a sharepoint list and I'm getting the following error
The solution I found was to use the Personal Gateway. Then add the SQL on premise to it, and the Sharepoint list just needed my credentials. It worked perfefctly an keeps running with scheduled refreses.
Fiala
Helper II
Helper IIHello, I have the same problem with connection on PBI Cloud. I´m trying to connect and i get an error:
- 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 SharePoint source are invalid. (Source at https://telcocloud.sharepoint.com/sites/PrevdzkaCCOperations.)"}},{"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.DataSourceOriginKind","detail":{"type":1,"value":"SharePoint"}},{"code":"Microsoft.Data.Mashup.CredentialError.DataSourceOriginPath","detail":{"type":1,"value":"https://telcocloud.sharepoint.com/sites/PrevdzkaCCOperations"}},{"code":"Microsoft.Data.Mashup.CredentialError.DataSourcePath","detail":{"type":1,"value":"https://telcocloud.sharepoint.com/sites/PrevdzkaCCOperations"}},{"code":"Microsoft.Data.Mashup.CredentialError.Reason","detail":{"type":1,"value":"AccessUnauthorized"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.DataSources","detail":{"type":1,"value":"[{\"kind\":\"SharePoint\",\"path\":\"https://telcocloud.sharepoint.com/sites/PrevdzkaCCOperations\"}]"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.Reason","detail":{"type":1,"value":"AccessUnauthorized"}}],"exceptionCulprit":1}}}
- Cluster URIWABI-NORTH-EUROPE-N-PRIMARY-redirect.analysis.windows.net
- Activity ID8ee43327-95ef-48a1-8337-935d0d3118c4
- Request ID2358cd56-df61-0ddd-2d20-1876f5fd3323
- Time2023-10-12 12:03:54Z
In PBI Desktop refresh works without any problem. Thank you for any advice.