Power Query times out intermittently

[leopardhawk]

Hello forum friends, I am having an issue with some power queries that will intermittently time-out while pulling data from a website that I control. What's weird is that there are no changes to the website or to the power queries yet sometimes they simply time-out and I get an error ("There weren't enough elements in the enumeration to complete the operation."). And sometimes they work with no issues at all. Also weird is that even if I get the error, I can manually refresh the ones that didn't refresh and they refresh almost instantly! It's driving me nuts trying to figure out what might be the problem. If anyone has any suggestions of what to look for, I will be grateful! Thanks!

 

[zweifuss]

The error message points to things like pivoting columns with same name, missing columns or rows, off by one errors and the like.

 

[leopardhawk]

@zweifuss Thank you. I will troubleshoot from that perspective.