Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion

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

    • Anonymous's avatar
      Anonymous
      Not 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's avatar
        Greg_Deckler
        Icon for Community Champion rankCommunity Champion
        Must be old SharePoint. Are you using Windows credentials?
  • v-yingjl's avatar
    v-yingjl
    Icon for Community Support rankCommunity 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:

    https://community.powerbi.com/t5/Service/The-credentials-provided-for-the-SharePoint-source-are-invalid/td-p/562521/page/3

     

    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.