Error in appending queries

All of the other queries simply have the error: "Loading blocked by failures with other queries."

This is setup as an append query in the query editor and pretty simple setup there.

I have already disabled "preview data/load data in the background" and have tried with "Enable parallel loading of tables" both checked and unchecked.

My only workaround so far is to go into query editor, refresh preview on the table being appended (Table B in my example) and then refresh data and it works.

Is it possible it's a timing issue that PowerBI is trying to refresh Table A with the append before Table B has been refreshed? The only change is that I have a new computer and wondering if my old slower computer was spreading out the refreshes far enough I just simply never ran into this before.

Is there a better way to append data from two tables besides doing it in the query editor as I am doing?