How to Add Rows in Power BI Query Editor

Trying to stack data from multiple tables into one? In Power BI, this is a core task for combining monthly reports, regional sales data, or information from different platforms. Getting this right is fundamental to building a report that actually tells the whole story. This guide will walk you through exactly how to add rows in the Power BI Query Editor using a few different methods.

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

Understanding "Adding Rows" in Power BI

Before we jump into the steps, it's important to clarify what "adding rows" means in Power BI. Unlike Excel, where you might insert a few blank rows, Power BI's Query Editor thinks about data in terms of entire tables. When you "add rows," you are usually performing an Append operation. Think of it like a stack of papers. If each sheet of paper is a table of data, appending them means stacking one sheet on top of another to create a single, taller stack.

The key requirement is that the sheets of paper (your tables) should have the same column layout. When you append queries in Power BI, it stacks the tables vertically, matching columns by their headers. This technique is incredibly powerful for consolidating datasets that have been split by time, location, or some other category.

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

Why Use the Power Query Editor?

The Power Query Editor is your data preparation workspace within Power BI. It's the engine room where you clean, shape, and transform raw data before it ever hits a single chart or visual in your report. Every successful Power BI report begins with well-structured data, and the Power Query Editor is where you make that happen.

Adding rows here ensures that the structural change is part of a repeatable, automated refresh process. Once you set up an append operation, every time you refresh your Power BI dataset, it will automatically pull in the latest data from all your source tables and stack them together correctly. This saves you countless hours of manual copy-pasting and data wrangling down the line.

Method 1: Appending Queries (The Most Common Way to Add Rows)

Appending is the go-to method for combining tables in Power BI. It’s designed specifically for stacking datasets with identical or very similar column structures.

When to Use Append Queries

This is the perfect tool for several common scenarios:

• Consolidating Monthly Files: You have sales data exported into separate files for January, February, and March. You can append them to create a single Q1 Sales table.
• Merging Regional Data: Your company has separate tables for sales from North America, Europe, and Asia. Appending allows you to create a global sales table for comprehensive analysis.
• Combining Similar Data Sources: You might have website traffic data from two different analytics tools that export with the same column headers. You can append them for a unified view.

Step-by-Step Guide: Appending Two Tables

Let's walk through the most basic scenario: combining two tables. For this example, imagine we have two queries: Sales_January and Sales_February.

1. Open the Power Query Editor: From the main Power BI Desktop window, go to the Home tab and click on Transform Data. This will launch the Power Query Editor.
2. Select Your Base Query: In the Queries pane on the left, click on one of the tables you want to append, like Sales_January.
3. Choose the Append Action: Go to the Home ribbon within the Power Query Editor. In the Combine group, you’ll find the Append Queries option.
4. Configure the Append Dialog Box: Let's choose Append Queries as New. A dialog box will appear. Since we're only combining two tables, keep the default selection. In the Table to append dropdown, select your second table, Sales_February.
5. Confirm the Append: Click OK. Power Query will create a new query, likely named Append1, in the Queries pane. You can right-click this new query and rename it to something more descriptive, like Q1_Sales_So_Far.
6. Review and Verify: Look at your new, combined table. Check that the row count is the sum of the rows from your two source tables. Scroll down to ensure the data from both tables has been stacked correctly.

Important Note: Power Query appends based on the column header names, not their order. If one table has a column named SaleDate and the other has Sales_Date, Power Query will create two separate columns, filling the missing values with nulls. This is the most common pitfall, so always double-check your column headers for consistency before appending!

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

Step-by-Step Guide: Appending Three or More Tables

What if you want to combine data for the entire first quarter? The process is very similar.

1. Start the Append: Again, select any of your queries and click Append Queries as New from the Home tab.
2. Select 'Three or More Tables': In the Append dialog box this time, select the radio button for Three or more tables.
3. Add Tables to Append: You'll see two boxes. The left box ('Available tables') shows all the queries you can append. The right box ('Tables to append') is where you build your list. Select each table you want to combine (Sales_January, Sales_February, Sales_March) and click the Add > button to move them to the right.
4. Confirm and Rename: Click OK. A new query will be generated containing all the data from the tables you selected. Rename it to something appropriate, like Q1_Sales_Complete.

Method 2: Manually Adding Rows with "Enter Data"

Sometimes you don't have a file or database connection, you just need to add a few rows of data by hand. This could be for a small lookup table or for quick testing. Power Query’s "Enter Data" feature is perfect for this.

When to Use the "Enter Data" Feature

• Creating a simple mapping table (e.g., a table that maps product codes to product categories).
• Hard-coding a few target values or budget numbers for a specific analysis.
• Quickly creating sample data to test a transformation or a DAX measure.

This method is not suitable for large amounts of data as it is completely manual and not easily updated.

How to Use "Enter Data"

1. Open the Command: In the Power Query Editor's Home ribbon, click on the Enter Data icon.
2. Create Your Table: A grid-like interface will appear. You can start typing data directly into the cells.
3. Name and Load: Give your new table a name at the bottom of the window, then click OK. The handwritten table will now appear in your Queries pane, and you can append it to another table if needed using the method we already covered.

Best Practices for Adding Rows

To avoid headaches and ensure your data is clean and reliable, follow these tips:

• Standardize Column Headers First: The most crucial step. Before you append, ensure the column names in all tables match exactly. Pay attention to spaces, capitalization, and underscores. A simple step to rename columns in each query before the append step can save you hours of troubleshooting.
• Check Data Types Post-Append: After combining tables, Power BI might assign an incorrect data type if there are inconsistencies. Click on each column header and use the Data Type dropdown in the Transform tab to ensure Dates are Dates, numbers are Whole Numbers, etc.
• Handle Nulls Intentionally: If one of your tables has an extra column that the others don't, the appended table will have null values for the rows that came from the tables missing that column. This is often fine, but be aware of it. You can use the Replace Values or Fill tools to manage these nulls if necessary.
• Use "Append Queries as New": Always default to this option. It keeps your data transformation steps clean, logical, and non-destructive, making it much easier to debug problems in the future.

Common Errors When Appending and How to Fix Them

Even with careful planning, things can sometimes go wrong. Here are two frequent issues and their solutions.

Problem: I have unexpected columns and lots of null values.

Cause: This is almost certainly due to inconsistent column headers. For example, one table has CustomerID and another has Customer_ID. Power Query sees these as two different columns.

Fix: Go back to your source queries (before the append step) and rename the columns so they match perfectly across all tables. After you fix the names, the appended query should automatically update and collapse them into a single column.

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

Problem: My total row count is wrong, or data seems missing.

Cause: This can happen if you accidentally chose 'Append Queries' instead of 'Append Queries as New' and then appended the wrong table, or if there's a filter applied to one of your source queries limiting the rows that are brought in.

Fix: Go to your source queries and review the Applied Steps pane on the right. Look for any "Filtered Rows" steps you didn't intend to apply. Also, verify in the new appended query that the 'Source' step is combining the correct tables.

Final Thoughts

Learning how to add rows in the Power BI Query Editor, primarily through the append feature, is a fundamental skill for anyone serious about data analysis. By stacking datasets correctly during the data preparation stage, you create a solid, unified foundation that allows you to build insightful and accurate reports that tell the complete story, not just a piece of it.

While mastering tools like Power BI is incredibly empowering, we know that getting all your data sources connected and cleaned up is often the most time-consuming part of the job. At Graphed, we automate this data preparation process entirely. Instead of wrestling with manual connections and transformations, you can simply connect your marketing and sales accounts, and then use natural language to ask for the charts and dashboards you need. We built it to turn hours of data prep and report building into a 30-second conversation, giving you back time to focus on strategy instead of report administration.