Forum Discussion

remig's avatar
remig
Frequent Visitor
8 years ago

Gateway - refresh failed - "The credentials provided cannot be used for the Web source."

Hi, I am trying to use the enterprise gateway, but I am getting the following type of 'refresh failed' message for every Sharepoint 2007 List (.aspx) source. [ Spoiler ] I think I tried ev...
Need Help
v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
8 years ago

Hi remig,

 

From your description, it seems that the dataset is configured to use on-premise data gateway personal mode. As the error message said, the credential is not valid. Please go to dataset settings, enter the correct credential for the web data source again. 

 

 

 

Best Regards,
Qiuyun Yu 

remig's avatar
remig
Frequent Visitor
8 years ago

Thank you v-qiuyu-msft. The dataset is definitely configured to use the on-premise gateway, and I have re-entered the credential a few times so far. I must have spent over 5 hours so far trying everything, and removing one source at a time from my data set, to realise that every .aspx source failed, all the other sources work fine, and they are pointing to the same sharepoint server, and I am using the same credentials.

 

 

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    8 years ago

    Hi remig,

     

    Please try to update the on-premise data gateway to the latest version. And share the on-premise data gateway service log (C:\Users\PBIEgwService\AppData\Local\Microsoft\on-premises data gateway\Gateway*.log ) around the time refresh failed with us. 

     

    Best Regards,
    Qiuyun Yu 

    • remig's avatar
      remig
      Frequent Visitor
      8 years ago

      Hi  v-qiuyu-msft, thank you so much for responding. Here is a log file containing the errors. Thank you sooo much for your help.

       

      Log file

       

Related content