How To Append Tables In Power Bi

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

  1. Select the table you want to append another table to.
  2. Click on the “Append Queries” button under the “Home” tab. This will open the “Append Queries” window.
  3. In the “Append Queries” window, select the table you want to append from the available options in the dropdown.
  4. 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

Read more interesting post

Leave a comment