Are you able to create new workbook off these datasources?
What about connecting from Desktop?
After researching, it looks like IE 11 (not sure about earlier versions) have a file transfer limit of about 2G. After downloading and installing Chrome, I was able to download the files with no problem. Comparing the files that did download to the files that didn't, if looks like the breakpoint was around 2G. So, if you see this problem, and can, use Chrome to download instead of IE.
So were all of them extracts?
Initially you said this: "these aren't the biggest published data sources".
Mentioning that they are all extract based could've nudged us in the right direction.
Good job figuring this out, Katherine!
Yes, they were all published extracts. I originally thought that size didn’t apply as I couldn’t correctly judge the sizes from the server. Some that I assumed were small, originally created by other users, were actually very large. I had to successfully download them before I could see the actual file sizes of the extracts. Once I was able to do that with Chrome I began to see the pattern.
Katherine Woods | Senior Software Engineer, Global Services Managed Analytics|