How to append queries in Power BI

To append queries in Power Query, you can use the "Append" transformation, which allows you to combine two or more tables by adding the rows from one table to the bottom of another table. Here is how you can do this in Power Query:

1. Open the Power Query Editor and select the tables that you want to append.

2. Click the "Home" tab in the ribbon, and then click the "Append" button in the "Combine" group.

3. In the "Append" dialog box, select the table that you want to append to the bottom of the other table, and then click "OK".

Power Query will create a new query that combines the two tables by appending the rows from one table to the bottom of the other. You can then apply additional transformations as needed, and load the resulting table back into your workbook or report.

Alternatively, you can also use the "Merge" transformation to combine two tables by matching rows from one table with rows from the other table based on common columns. This can be useful when you want to join two tables based on a shared key, rather than simply appending the rows from one table to the bottom of the other.

Overall, both the "Append" and "Merge" transformations are powerful tools for combining data from multiple sources in Power Query and can help you save time and effort when preparing data for reporting or analysis.