Multiple remote sources in single query - error handling at source

Thank you so much for your help - unfortunetly I didnt get chance to try your method before solving for myself. 

Because it was the first time I was trying to load the data to a table in my workbook it was failing completion due to the IDs that hold no order records. To overcome this I just needed to load every row within power query first (Was around 10,000 rows so took a while scrolling to the bottom of the table to load more) then I just removed the errors from the column so when I went to load it to table it worked perfectly! 🙂 

Thanks again, 

Will