How to Add New Data to Existing Data in Power BI

Your Power BI report is live, but your data isn't static. Whether you have new monthly sales figures in a separate spreadsheet or want to enrich your existing data with customer details from another system, learning how to add new data to your existing model is essential. This guide will walk you through the primary methods for integrating and expanding your datasets directly within Power BI.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Not Just Hit 'Refresh'? Understanding Power BI's Data Refresh

Before diving into adding totally new data, it's important to understand the role of the 'Refresh' button. When you refresh a Power BI dataset, you are telling Power BI to go back to the original data sources you've already connected to and pull in the latest information. It re-runs the queries and transformations you've set up in the Power Query Editor.

Refreshing is the perfect solution when:

• New rows have been added to your original source file (e.g., your sales team added yesterday's transactions to the main Excel sheet).
• Values within your source data have been updated (e.g., a customer's status changed from 'Prospect' to 'Client' in the database).
• The structure of your data - the columns and their names - has remained exactly the same.

However, refreshing will not work if you need to bring in data from a completely new file (like a February sales report when your original connection was only to the January report) or a different data source. For that, you need to use Power Query's append or merge functions.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Method 1: Stacking Data with Appending Queries

Appending is the process of stacking data from two or more tables that have the same structure. Think of it as adding more rows to the bottom of your existing table. This is incredibly common when you receive data in periodic batches, like monthly or quarterly reports.

A common scenario: You have an Excel workbook with a separate worksheet for sales from Q1, Q2, Q3, and Q4. Your goal is to create one single "Annual Sales" table in Power BI that contains all four quarters.

Step-by-Step Guide to Appending Data

For this walkthrough, we'll assume you’ve already loaded your Q1 and Q2 sales tables into Power BI. Now you want to add Q3 data.

1. Get Your New Data: First, you need to bring the new table into Power BI. From the Home ribbon, select Get Data and connect to your source (e.g., an Excel workbook), loading the Q3 sales table.
2. Open Power Query: On the Home ribbon, click Transform data. This opens the Power Query Editor, which is where all data manipulation happens. You should see your tables listed in the Queries pane on the left.
3. Find the Append Command: Select the table you want to serve as your primary table (e.g., Q1_Sales). In the Home tab of the Power Query Editor, find the Append Queries button in the "Combine" section.
4. Configure the Append: A dialog box will pop up. Since we have more than two tables to combine, select the Three or more tables option. Now, select your Q2_Sales and Q3_Sales tables from the "Available tables" list and click Add > to move them to the "Tables to append" list. Your Q1_Sales table will already be there. Click OK.
5. Review and Rename: Power Query will instantly create a new query, likely named "Append1". You'll see a single table with all the rows from Q1, Q2, and Q3 stacked neatly. It’s good practice to rename this new query to something meaningful, like "Total_Sales_YTD".
6. Close & Apply: Once you're happy with the results, click Close & Apply in the top-left corner to load your new, combined table into your Power BI data model, ready for creating visuals.

Pro Tips for Appending

• Column Headers Matter: Appending works by matching column names. If one table has a column named "Sale_Date" and another has "DateofSale," Power Query will treat them as two separate columns. Ensure your column names are consistent across all tables before you append.
• Automate with "Folder" Connection: If you regularly receive files in the same format (e.g., a "Monthly Sales" folder where you drop new CSV files), use the Get Data > From Folder connector. Power BI can automatically combine all files in that folder into one table. When you add a new file to the folder and refresh, it will be automatically appended!

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Method 2: Weaving Data Together with Merging Queries

Merging is the horizontal equivalent of appending. It's used to combine two tables that have different data but share a common column, often called a key. If you've ever used a VLOOKUP in Excel or a JOIN in SQL, you already understand the concept of merging. You're enriching one table with columns from another.

A common scenario: You have a Sales table containing OrderID, ProductID, and Quantity. You have a separate Products table with a lookup list containing ProductID, ProductName, and ProductCategory. You want to analyze sales by ProductCategory, so you need to add the category information to your sales data.

Step-by-Step Guide to Merging Data

1. Open Power Query: With both tables loaded into Power BI, go to Transform data to open the Power Query Editor.
2. Start the Merge: Select the table you want to add columns to. In our case, this is the Sales table (sometimes called the 'base' or 'left' table). In the Home tab, click Merge Queries. As before, select Merge Queries as New to create a new, combined table as a best practice.
3. Configure the Merge: The Merge dialog box appears.
4. Choose the Join Kind: The "Join Kind" defines how Power BI combines the rows. The default, Left Outer, is the most common and means "keep all rows from the first table (Sales) and bring in matching ones from the second (Products)." This is exactly what we want.
5. Expand the New Column: After you click OK, you'll see a new column has been added to your table, but the cells just say "[Table]". Don't worry! This is a structured column containing all the data from the Products table for the matching ProductID. Click the two-arrow icon in the column header to expand it.
6. Select Your Columns: A dropdown list of all the columns from the Products table will appear. Choose the specific columns you want to add to your Sales table, like ProductName and ProductCategory. It's a good idea to uncheck the "Use original column name as prefix" box to keep your new column names clean (e.g., ProductCategory instead of Products.ProductCategory). Click OK.
7. Done!: You now have a new, enriched query that includes your sales data alongside the product details from your lookup table. You can rename this query, click Close & Apply, and start building visuals based on product category.

Method 3: Creating New Columns with DAX

Sometimes "adding data" doesn't mean connecting to a new source at all. It means creating new information based on the data you already have. This is where DAX (Data Analysis Expressions), Power BI's formula language, comes in. By writing a simple DAX formula, you can create a new calculated column in any of your tables.

A common scenario: Your Sales table has a Revenue column and a ProductCost column, but you want to analyze profit. You can create a new Profit column by calculating the difference.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step-by-Step Guide to a DAX Calculated Column

1. Go to the Data View: In the main Power BI Desktop window, click on the table icon on the far left to switch to the Data view.
2. Select Your Table: Click on your Sales table in the Fields pane on the right.
3. Add a New Column: From the Table Tools ribbon at the top, click New column.
4. Write the Formula: A formula bar will appear below the main ribbon, similar to Excel. Here you write your DAX expression. To calculate profit, you would type:
5. Commit the Change: Press Enter. Power BI will calculate the profit for every single row in your table and populate the new Profit column. You can now use this column in your charts, tables, and slicers just like any other field.

Which Method Should You Use? A Quick Guide

Feeling a bit lost on which approach to take? Here’s a simple cheat sheet:

• Use Data Refresh when... you only have new rows in your original, already-connected data sources. Your table structure hasn't changed.
• Use Appending Queries when... you have multiple tables or files with the exact same columns that you want to stack into a single, comprehensive list.
• Use Merging Queries when... you have two tables with different data but a shared key column, and you want to add columns from one to the other.
• Use a DAX Calculated Column when... you need to create a new field by performing a row-by-row calculation on data that's already in your table.

Final Thoughts

Mastering how to add new data to an existing Power BI report moves you from a static report builder to a dynamic analyst. By understanding when to refresh, append, merge, or use DAX, you have a complete toolkit for creating comprehensive data models that accurately reflect all of your business activities, not just a snapshot from day one.

Learning the ins and outs of business intelligence tools like Power BI can take time. But what if you could bypass the steep learning curve entirely? At Graphed, we connect directly to your marketing and sales platforms - like Google Analytics, Shopify, and Salesforce - in seconds. Instead of navigating Power Query, you can simply ask in plain English, "show me a dashboard comparing Facebook Ads spend vs. Shopify revenue by campaign," and watch as it builds a real-time report for you. Our goal is to automate the busy work of manual reporting so you can get straight to the insights.