data load issues: "loading blocked by other queries" and other errror

[user9394]

I'm trying to load a dataset from a SQL DB and since the table is large (10mil+ rows), I've split it to 5 smaller tables (seems to be more successful that way)
When I add another dimension to these datasets, all my tables refresh together and I get the following issue for my tables.
Loading blocked by failures with other queries.

Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.

how do I go about resolving this and what is the exact cause of this?  anything I can do on my end so my data will load?

[v-jingzhang]

Hi @user9394 

Which query does the second error message occur on? Can you test if you refresh this query only (uncheck the option "Include in report refresh" for other queries), will this error occur? If you filter this query to return a small sub set of rows, will this error occur? Does this query connect to a table in the same SQL BD? 

Best Regards,
Community Support Team _ Jing