web.page not refreshing through gateway

[jwhitf4770]

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:

[v-yingjl]

Hi @jwhitf4770 ,

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:

https://community.powerbi.com/t5/Service/The-credentials-provided-for-the-SharePoint-source-are-inva...

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

Well, you should not be using the Web connector for SharePoint, use a SharePoint connector for SharePoint.

[jwhitf4770]

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]

Must be old SharePoint. Are you using Windows credentials?

[jwhitf4770]

I am using Windows Credentials.   It is not my credentials but a user that has access to the lists and folders.