visual has exceeded the available resources

This might be a far too simple solution for you but I've been struggling with this for weeks with one table refusing to show more than 10 rows on a very small dataset (3000 rows total) without exceeding resources. I tried everything to optimise what I could without success, but eventually what fixed it was going into each of the settings of the columns in the visualizations pane and seeing one of my numeric columns was set to 'sum' when it didn't need to be. I changed it to 'don't summarize' and the problem was fixed. Instant refreshing of the table instead of 10 minutes+ and no more error message. Frustratingly simple in the end, I really hope this helps if you are using tables that aren't loading