Convert existing query to an append query?

Two options:

1. After refresh, copy the query to a combined sheet with VBA. You can append it to the existing table everytime.
2. If you don't want to use VBA, you need a workaround with the help of the datamodel. To achieve this, you need to add a table to your data model, retrieve it in a worksheet (you can hide this sheet), and then reference this table in Power Query. It sounds more complicated than it actually is.

Attached an example with the datamodel (option 2). Eventually, you can hide the datamodel sheet.
For testing, try adding values to the blue table. Then hit "Refresh All" and see what happens. The green table next to the blue table will grow. Already loaded records stay in the table as well

Oh wow. Thanks. I am closer to visualizing how it will work. The table my M-code referenced is a connection only so that I could marry the key fields with other tables. The final product is a Merge between the current inventory, the current transactions, and any current comments. So I should create a table in excel that matches what I currently have stored in the datamodel. Then reference THAT new table in the query that is in the data model. change the connection only to a table in excel proper. Did I get that right? I really appreciate the help. Thanks again.

To answer the question posed in post #3, it would be helpful to see a sample file.
Let us know if you have any questions.