Issue refreshing, recently added Odata feeds, issue with memory

I keep throwing an error while I am trying to refresh my data. At first it said ODB error and then an error about memory: Memory error: Memory Allocation failure : Not enough memory resources are available to process this command. . Try simplifying or reducing the number of queries.

So I tried unclicking "include in refresh" on several tables got this error: Exception of type 'System.OurOfMemoryException' was thrown with the following details: