Power Query takes too long to access web content

[Fernando_Palma]

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

[v-sshirivolu]

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]

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

[lbendlin · Accepted solution]

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

[BA_Pete]

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