Forum Discussion
web.page not refreshing through gateway
I am connecting to the On-Premise SharePoint list and folder. I can refresh the data from the desktop.
The source is:
= Web.Page(Web.Contents("http://......../AIM/EQ%20File%20Transfer/_Archived%20AIM%20Requests", [Timeout=#duration(0, 0, 60, 0)]))
The gateway connects:
I am using a service user
However, on refreshes, I get the following 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 cannot be used for the Web source. (Source at http://laurelnet/sites/maintenance/AIM/EQ%20File%20Transfer/Forms/AllItems.aspx.)"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.CredentialError.DataSourceKind","detail":{"type":1,"value":"Web"}},{"code":"Microsoft.Data.Mashup.CredentialError.DataSourcePath","detail":{"type":1,"value":"....../AIM/EQ%20File%20Transfer/Forms/AllItems.aspx"}},{"code":"Microsoft.Data.Mashup.CredentialError.Reason","detail":{"type":1,"value":"CredentialInvalid"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.DataSources","detail":{"type":1,"value":"[{\"kind\":\"Web\",\"path\":\"....../AIM/EQ%20File%20Transfer/Forms/AllItems.aspx\"}]"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.Reason","detail":{"type":1,"value":"CredentialInvalid"}}],"exceptionCulprit":1}}} Table: AIM File Transfer.
Also when I look at Data Source Credentials, it just spins:
5 Replies
- Greg_Deckler
Community Champion
Well, you should not be using the Web connector for SharePoint, use a SharePoint connector for SharePoint.
- AnonymousNot applicable
I have tried that. This an ON Premises sharepoint. We we use the On Premise sharepoint we get JSON errors and researching this it said to use the web.page connector.
Any suggestions?
- Greg_Deckler
Community Champion
Must be old SharePoint. Are you using Windows credentials?
- v-yingjl
Community Support
Hi Anonymous ,
It seems like the credentials of data source are invalid. Please try to update the latest version of gateway and check the credentials when using SharePoint connector to connect.
Perhaps the following simliar case could help you:
Best Regards,
Yingjie LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.