To append tables in Power BI, you can use the Query Editor. Here’s a step-by-step guide with examples:
Step 1: Open Query Editor
Open the Power BI Desktop application and click on the “Edit Queries” option under the “Home” tab.
Step 2: Append Tables
- Select the table you want to append another table to.
- Click on the “Append Queries” button under the “Home” tab. This will open the “Append Queries” window.
- In the “Append Queries” window, select the table you want to append from the available options in the dropdown.
- Click on the “OK” button to append the selected table.
Example:
Let’s say you have two tables: “SalesData” and “OrderData”. You want to append the “OrderD