All of our data sources (Excel files) are hosted on Sharepoint. There are only 6 tables in this dataflow, the files being less than 1gb in total size. I am also pulling another 6 smaller data/definition lookup tables (also Excel files hosted on Sharepoint) from a dataflow that has no gateway, while the one that is generating the error has one - and I can't seem to remove the gateway either.
I've tried setting up incremental refresh but that isn't helping because I can't get the dataflow to complete the refresh after setting it up. Anyone know a solution to this problem?