Question: what is the difference between merge and append in power query?
Answer: There are two primary ways of combining queries: merging and appending. When you have one or more columns that you'd like to add to another query, you merge the queries. When you have additional rows of data that you'd like to add to an existing query, you append the query.