SharePoint Online slow refresh

Same here - to the point where it's becoming unusable when my line speed drops - which is often the case unfortunately. My problem is not so much the slowness of the query, but rather the fact that I don't know how to stop it from doing the query every single time I press enter to add a new line. It takes around 10 to 40 minutes (yes, minutes) to refresh and apply the query changes - it is not a large dataset, merely a few projects' data I'm bringing over from Microsoft Project (online). Surely, since the data is already loaded into memory there should be a way to set it to use the memory instead of querying the source, until such time that I actually want to refresh from SharePoint, right? Perhaps someone from Microsoft could help explain this to us?