How to Add Data to Existing Table in Power BI

Adding new data to an existing table is one of the most common and necessary tasks in Power BI. Whether you're refreshing your dataset with last month's sales numbers or enriching it with additional details, knowing how to do it efficiently is a game-changer. This tutorial will walk you through the different ways to add data to tables in Power BI using its powerful data transformation tool, the Power Query Editor.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Why Bother Adding Data to Existing Tables?

Before diving into the "how," let's quickly cover the "why." Consolidating your data into a clean, unified table helps you create more powerful and coherent reports. Manual data prep often means copying and pasting new information into a master spreadsheet - a process that's slow and prone to errors. In Power BI, you set up the process once, and it becomes refreshable and automated.

Common scenarios include:

• Time-Based Updates: Appending new weekly, monthly, or quarterly data (e.g., adding May's sales figures to a table that already contains January-April).
• Combining Similar Datasets: Unifying data from different sources that share the same structure, like sales reports from different regional offices or advertising data from multiple platforms.
• Enriching Your Data: Adding descriptive context to an existing table, such as adding product names and categories to a sales transaction table that only has a ProductID.

Mastering this skill saves you from rebuilding reports and ensures your analysis is always based on the most current and complete information available.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

The Two Core Methods: Append vs. Merge

In Power BI's Power Query Editor, there are two primary ways to combine data: Appending and Merging. Understanding the difference is crucial because they solve very different problems.

• Append Queries: Think of this as stacking tables on top of each other. Appending adds new rows of data to an existing table. This method works when the tables you are combining have the same or very similar column headers. For example, you would append May's sales data to April's sales data because the structure is identical.
• Merge Queries: This is like a VLOOKUP in Excel or a JOIN in SQL. Merging adds new columns to a table by matching rows from another table based on a shared key or identifier. For example, you would merge a Product Details table into your Sales table using a common ProductID column to add the product name.

Let's look at how to perform both of these operations step-by-step.

Method 1: How to Append Data (Adding More Rows)

Appending is your go-to method for combining files with identical structures. Imagine you have a CSV file with Q1 sales data and you just received a new file with Q2 sales data. Here's how to combine them.

Step-by-Step Guide to Appending Two Tables

1. Open the Power Query Editor: In your Power BI Desktop report, click on the Transform data button in the Home tab. This will open the Power Query Editor, where all data transformation takes place.
2. Load Your Data: First, ensure both of your data tables are loaded into Power Query. Use New Source to connect to your Q1 sales file and your Q2 sales file. You should now see both queries listed in the Queries pane on the left (e.g., Q1_Sales and Q2_Sales).
3. Select Your Main Table: In the Queries pane, click on the table you want to add the new data to. In our case, this will be Q1_Sales.
4. Choose Append Queries: With Q1_Sales selected, go to the Home tab in the ribbon and click on the Append Queries command. A dropdown menu gives you two options:
5. Configure the Append Operation: A dialog box will pop up. Since we're combining two tables, leave "Two tables" selected. In the dropdown menu for "Table to append," select Q2_Sales and click OK.
6. Review and Apply: Power Query will generate a new table (likely named Append1). You'll see that it contains all the rows from both Q1_Sales and Q2_Sales. Rename this table to something descriptive, like Total Sales. Once you're happy with the result, click Close & Apply in the top-left corner to load your new, combined table into your data model.

Your visuals will now be able to use the complete dataset from the Total Sales table.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Pro Tip: The Ultimate Way to Append - Combine Files from a Folder

Appending files one by one is fine for a one-off task, but what if you get a new sales file every single month? You don't want to repeat the steps above every time. The most efficient and scalable solution is to point Power BI to a folder and let it automatically combine any files it finds there.

Steps to Append from a Folder

1. Get Data from a Folder: In Power BI Desktop, go to Get data > More... and search for Folder. Click Connect.
2. Provide the Folder Path: Browse to or paste the path of the folder where you store your report files (e.g., C:\Monthly Reports\Sales).
3. Combine & Transform: Power BI will show you a preview of the files in that folder. Click the Combine & Transform Data button.
4. Set the Sample File: Power Query needs to know how to transform each file. It will use the first file in the folder as an example. A dialog will show a preview of how it interprets the data. Typically, the default settings work fine. Click OK.

Power Query now automatically performs all the necessary steps to combine every file in that folder into a single table. The best part? Next month, when you drop the March sales file into that same folder and hit Refresh in Power BI, it will automatically be added to your dataset. No extra steps needed.

Method 2: How to Merge Data (Adding New Columns)

Merging is used to enrich a data table with new columns from another. For this example, let's say you have a Sales table containing SaleID, ProductID, and Amount, and a separate Products table containing ProductID, ProductName, and ProductCategory. Our goal is to add the product name and category to the Sales table for easier analysis.

Step-by-Step Guide to Merging Two Tables

1. Open the Power Query Editor: As before, click on Transform data from the Home tab.
2. Load Your Tables: Make sure both your Sales table and your Products table are loaded into Power Query.
3. Initiate the Merge: Select the primary table you want to add columns to - in this case, the Sales table. In the Home tab, click on Merge Queries. This will modify your existing Sales table.
4. Configure the Merge Dialog:
5. Expand the New Column: A new column named Products will be added to your Sales table. The cells in this column contain the word "Table". Click on the expand icon (a button with two arrows) in the column header.
6. Select Columns to Add: A dropdown list will appear with all the columns from the Products table. Deselect ProductID (since you already have one) and uncheck "Use original column name as prefix." Check the boxes for ProductName and ProductCategory. Click OK.
7. Verify and Apply: Your Sales table now has two new columns! You can see the corresponding product name and category for each transaction. Click Close & Apply to load the changes.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Final Thoughts

Learning how to add data to existing tables is fundamental for building robust and scalable reports in Power BI. By using Power Query to append (stack tables) or merge (enrich with new columns), you automate your data prep workflows, reduce errors, and ensure your reporting data model is clean and comprehensive from the start.

Although Power Query is powerful, managing these pipelines can sometimes feel like a full-time job. We created Graphed to eliminate this exact kind of data busywork. Instead of configuring transforms and schemas, you just connect your sources - like Google Analytics, Shopify, or your own spreadsheets - and our AI handles building the unified data model for you. From there, you just describe the dashboards you need in plain English and have a real-time, interactive dashboard in seconds, skipping the Power Query learning curve entirely.

If you're looking for an easier and faster way to handle your data analytics and reporting, take a look at Graphed today.