In Power BI, appending queries combines rows from two or more tables, adding data vertically into a single table, which is done in the Power Query Editor by selecting Home > Transform Data > Append ...

APPEND VS MERGE IN POWER QUERY — KNOW THE DIFFERENCE THAT DEFINES YOUR DATA MODEL Many professionals use Append and Merge interchangeably in Power Query. That is a costly mistake. They serve different ...