Power BI merge tables same columns code example

Example: Power BI merge tables same columns

// This is for combining tables with the Same Columns, appending one's rows to another ("Vertical" join)

1. Go to Power Query
2. Click on one of the table queries you want to join
3. Click Append Queries, select the "as new" option (typically the safest option)
4. A new window will appear where you can combine all the queries that you want.