Graphed LogoGraphed
Graphed LogoGraphed
How It WorksAgentsIntegrationsPricing

How to Append Data in Power BI

Cody Schneider••9 min read

Combining data from different spreadsheets, files, or tables is a daily reality for anyone working with data. If you have monthly sales reports in separate CSVs or regional data siloed in different files, Power BI's Append feature is the tool you need. This article will show you exactly how to stack your data together, creating a single, clean table for easier analysis and reporting.

GraphedGraphed

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.

Watch Graphed demo video

What Exactly is Appending in Power BI?

Think of appending as stacking books on top of one another. You have several tables with the same structure (i.e., the same columns), and you want to vertically combine them into a single, taller table. If you have a table with January sales data and another with February sales data, appending them creates a new table containing all the sales rows from both January and February.

It's important not to confuse this with merging data. Merging in Power BI is like a VLOOKUP in Excel, it's used to add new columns to a table by matching a key from another table. Appending is all about adding new rows.

  • Append: Joins tables vertically, increasing the row count.
  • Merge: Joins tables horizontally, increasing the column count.

For example, if you have sales data for each quarter of the year saved in four separate files (Q1_Sales.csv, Q2_Sales.csv, etc.), you would append them to create a single Annual_Sales table.

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.

When Should You Append Queries?

Appending is useful in many day-to-day scenarios. You'll find yourself using it whenever you need to consolidate data that's been split across multiple sources. Here are some common situations:

  • Combining Time-Based Data: This is the most popular use case. You have weekly, monthly, or yearly data files and need to create a master timeline for analysis. (e.g., combining January_Website_Traffic.csv, February_Website_Traffic.csv, and March_Website_Traffic.csv).
  • Consolidating Similar Data Categories: Imagine you have marketing performance data from different ad platforms like Facebook Ads, Google Ads, and LinkedIn Ads. If you export reports with the same columns (like Campaign Name, Spend, Clicks, Conversions), you can append them all into one master marketing performance table.
  • Aggregating Data from Different Regions or Divisions: A business with distinct sales regions (e.g., North America, Europe, Asia) might have separate data files. Appending lets you bring all that regional data together to see a global performance view.
  • Archiving Historical Data: You might have a "live" data connection for the current month's sales and static files with data from previous years. You can append the static files with the live data to build a complete historical view.

Before You Append: A Quick Pre-Flight Checklist

To avoid headaches later, a little preparation goes a long way. Power BI is smart, but it can only work with what you give it. Your appended queries will only be clean and accurate if your original tables are consistent. Check these two things first.

1. Ensure Consistent Column Headers

This is the most critical rule. The column names in each table you want to append must match exactly. Power Query is case-sensitive and literal. If one table has a column named Sales Amt and another has Sales_Amt, Power Query will see them as two different columns. The result will be a messy table with extra columns filled mostly with null values.

To Fix It: Before appending, open each query in the Power Query Editor, double-click the column headers, and rename them to be identical across all your tables. For example, ensure all sales amount columns are named exactly Sale Amount.

2. Ensure Consistent Data Types

Along with column names, the data type of matching columns should also be consistent. If the Date column is a Date type in one table and a Text type in another, you'll run into errors when you try to create reports or perform calculations. Power BI is generally good at detecting data types on its own, but it's always wise to double-check.

To Fix It: In the Power Query Editor, click the icon in the column header (e.g., an ABC icon for text, 123 for a whole number, a calendar for a date) and set the correct data type for each column in all your source tables before appending.

GraphedGraphed

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.

Watch Graphed demo video

How to Append Data in Power BI: A Step-by-Step Guide

Once your data is prepped, the appending process itself is straightforward. Let's walk through it using Power Query Editor, the engine behind all data transformation in Power BI. You can access it by clicking the Transform Data button on the Home tab of Power BI Desktop.

Scenario 1: Appending Two Tables Together

Let’s start simple. Say we have two queries loaded into Power BI: Sales_January and Sales_February. Our goal is to combine them into a single table for Q1 reporting.

  1. Open Power Query: With your data loaded into Power BI, click Transform Data from the Home ribbon to open the Power Query Editor.
  2. Select Your Main Table: In the Queries pane on the left, click on the first table you want to use as your base, for example, Sales_January.
  3. Find Append Queries: On the Home tab in the Power Query ribbon, find the Append Queries button in the "Combine" section.
  4. Choose Your Append Type: When you click the Append Queries dropdown, you get two choices:
  5. Configure the Append: A new window will pop up. Since we're only combining two tables, the default view is what we need. Select your Sales_January table as the "Primary table" and Sales_February as the "Table to append to the primary table."
  6. Click OK: After clicking OK, Power Query creates a new query, likely named Append1, in the Queries pane. This table now contains all the rows from both January and February.
  7. Rename Your New Query: It's good practice to rename this new table to something descriptive. Right-click Append1, select Rename, and change it to something like Sales_Combined.

That's it! You can now Close & Apply to load this new, comprehensive table into your data model for visualization.

Scenario 2: Appending Three or More Tables

What if you have data for an entire year, split into four quarterly files: Sales_Q1, Sales_Q2, Sales_Q3, and Sales_Q4? The process is nearly identical.

  1. Follow steps 1-4 from the previous scenario, selecting Append Queries as New.
  2. Select "Three or More Tables": In the Append window that pops up, click the radio button for Three or more tables.
  3. Add Your Tables: You'll see a list of Available tables on the left and an empty Tables to append box on the right. Select all the tables you want to combine (Sales_Q1, Sales_Q2, etc.) and click the Add >> button.
  4. Verify and Click OK: Confirm that all your desired tables are in the right-hand box and click OK.
  5. Rename and Finish: Just like before, a new appended query will be created. Rename it to Annual_Sales, and you’re ready to Close & Apply.

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.

The Pro Method: Automatically Append All Files in a Folder

Manually appending is great, but what if you get a new sales file every single month? You don't want to repeat this process every time. A much more powerful and automated approach is to connect Power BI to an entire folder.

When you do this, Power Query will automatically combine every file in that folder. Even better, when you drop a new file into the folder later and refresh your Power BI report, the new data will be added automatically.

  1. Get Data from a Folder: In Power BI Desktop, click Get Data > More... and search for or select Folder. Click Connect.
  2. Provide the Folder Path: Browse to the folder where you store your related files (e.g., your "Monthly Sales Reports" folder).
  3. Combine Files: A file list window will appear, showing all the files in that folder. Instead of loading this list, click the Combine & Transform Data button at the bottom.
  4. Select a Sample File: Power BI needs to know how to interpret the files. It will ask you to use one file as a sample. Typically, the first file is fine. Select it and click OK.
  5. Let Power Query Do the Magic: Power Query will now perform a series of steps automatically. It creates a sample query to define the transformation logic (like promoting headers and setting data types) and then creates a function to apply that logic to every single file found in the folder. The very last step in this sequence is appending all the processed files into one big table.
  6. Check and Load: The result will be a single, combined table. You can watch as it processes each file and combines them. Once it’s done, you can Close & Apply. Now, any time a new CSV or Excel file is added to your folder, a simple data refresh in Power BI will append it to your master table.

Common Append Problems and How to Fix Them

Sometimes things don't go perfectly. Here are a few common issues and their solutions.

  • Problem: Extra Columns Full of Nulls. This is almost always caused by mismatched column names. A tiny spelling difference (StoreID vs. Store_ID) will create two columns.
  • Problem: Data Types Cause Errors. You try to do a SUM on a sales column, but it errors out or gives incorrect results. This happens when the data type wasn't set correctly prior to appending. For example, a sales column may have been misidentified as Text in one of your source files.
  • Problem: Unexpected Row Counts or Duplicates. The total number of rows in your final table is higher than expected. This means there was overlapping data in your source files. Remember, appending simply stacks data, it doesn't check for or remove duplicates.

Final Thoughts

Mastering how to append data in Power BI is a fundamental skill for moving beyond simple reports and into robust data analysis. By stacking your tables correctly - whether manually or through the powerful folder import method - you can create a single, unified dataset that’s ready for you to slice, dice, and visualize effectively.

The whole routine of downloading CSVs, cleaning them, and stacking them in Power BI is exactly the type of manual drudgery we wanted to eliminate. At its core, it's about connecting scattered data sources to get a complete picture. With Graphed, we automate the connection process to popular platforms like Google Analytics, Shopify, Facebook Ads, and Salesforce. Instead of manual exports and transformations, you just connect your accounts once, then use plain English to build real-time dashboards that pull your cross-platform data together instantly.

Related Articles