Forum Discussion

Fernando_Palma's avatar
Fernando_Palma
New Member
9 months ago
Solved

Power Query takes too long to access web content

I have a Power Query that access Excel data in a sharepoint server.

 

It takes about 30 minutes just to have the "Access Web content" credentials window to appear and another 30 minutes to connect and start loading.

 

What can be the cause?

 

BR, Fernando

  • You have upgraded to Windows 11 and your company's DLP policies have not been updated accordingly.

4 Replies

  • Hi Fernando_Palma ,

     

    Most likely to be a network issue I would think. Either your work network/firewall isn't playing nice or your home wifi might be lacking bandwidth if you're WFH.

    It could also be to do with the connector you're using. Try using the SharePoint.Files connector rather than a web connector.

     

    Pete

  • You have upgraded to Windows 11 and your company's DLP policies have not been updated accordingly.

  • v-sshirivolu's avatar
    v-sshirivolu
    Community Support

    Hi Fernando_Palma ,

    I would also take a moment to thank BA_Pete , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
     

    I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions

     

    • v-sshirivolu's avatar
      v-sshirivolu
      Community Support

      Hi Fernando_Palma ,
      I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions