How to Add More Data to an Existing Power BI Report

Your Power BI report is built, the visuals look great, and your team loves it - but data never stands still. This guide will walk you through the most common ways to add more data to an existing Power BI report, from simply updating with the latest numbers to integrating entirely new data sources.

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

First, Understand Your Data Connection

Before you add anything, it helps to know how your report gets its data. In Power BI, you generally have two main connection types that affect how you update information:

• Import: This is the most common method. Power BI takes a copy of your data from the source (like an Excel file or a database) and stores it within the Power BI file itself (.pbix). To see new data, you must perform a refresh.
• DirectQuery: This method connects live to the data source. When you interact with a visual, Power BI sends a query directly to the source to get the latest data. You don't need to "refresh" in the same way, but this method is only available for certain data sources, typically large databases.

This article will focus primarily on the Import method, as it’s what most users work with for everyday reports built from files, spreadsheets, and common cloud applications.

Method 1: Refreshing Your Report with New Rows

This is the most frequent task you'll perform. It’s for when new data has been added to your original source file or database table - for example, new sales records for the last week have been added to the master Excel sheet.

The goal here isn't to add new kinds of data but to update the existing tables with the latest entries.

How to Refresh Your Data in Power BI Desktop:

1. Open your Power BI file (.pbix).
2. In the Home ribbon, you'll see a Refresh button.
3. Click it. Power BI will reconnect to every data source in your report, check for new or updated rows, and load them into your data model.
4. Your visuals will automatically update to reflect the new data.

That's it! If you haven't changed the file path or your login credentials, this process is usually seamless.

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

Automating Refreshes in Power BI Service

Manually clicking the refresh button is fine for your own use, but when you share reports with a team, you want them to update automatically. After publishing your report to the Power BI Service (your online workspace), you can set up a scheduled refresh.

• Go to your workspace in Power BI Service and find your report's dataset.
• Click the three dots (...) and select Settings.
• Expand the Scheduled refresh section.
• Toggle it on, choose a refresh frequency (e.g., Daily, Weekly), select a time zone, and set a time for the refresh to happen.

Now your report will stay up-to-date for everyone without you having to open it and refresh it yourself.

Method 2: Adding New Columns to an Existing Table

Sometimes your source data changes its structure. Imagine your marketing team starts tracking a new metric, and they've added a "Campaign Source" column to your main sales spreadsheet. Here's how to get that new column into your Power BI report.

1. Navigate to the Home tab in Power BI Desktop and click Transform data. This opens the Power Query Editor, which is where you manage your data connections and transformations.
2. On the left, you'll see a list of all the queries (tables) in your report. Select the one that corresponds to your updated data source.
3. On the right, look at the APPLIED STEPS panel. This lists every series of transformations applied to your data. Find the step named Source or Navigation.
4. After refreshing your data preview (using the refresh button within Power Query), the new column should appear. If it does, you can simply click Close & Apply in the top-left corner.

What If the New Column Doesn't Appear?

Sometimes a previous step in Power Query explicitly removes other columns. Look for a step called Removed Other Columns. If you see one:

• Select that step. The formula bar at the top will show a list of column names that were kept.
• Click the gear icon next to the step name in the Applied Steps list.
• A dialog box will appear showing all available columns. Your new column will likely be unchecked. Just check the box next to its name and click OK.

Once you see the new column in the Power Query editor's data preview, click Close & Apply. Your new column will now be available in the Data pane in your report, ready to be used in visuals.

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

Method 3: Adding an Entirely New Data Source

This is for when you want to bring in a completely separate set of data. For example, your report contains sales data from Shopify, but now you want to add website traffic data from a Google Analytics export stored in a CSV file.

1. In the Home ribbon of Power BI Desktop, click on Get Data and select the appropriate connector type for your new source (e.g., Text/CSV, Excel, etc.).
2. Follow the prompts to connect to your new file or service. When the Navigator window appears, select the table(s) you wish to add.
3. Crucially, click Transform Data instead of Load. It's always a best practice to review and clean your new data in Power Query before adding it to your model.
4. Once you're in Power Query, you can perform any necessary cleaning steps - like renaming columns, changing data types, or removing errors. When you're done, click Close & Apply.

The new table will now appear in your Data pane. But there's one more essential step: creating a relationship.

Building Relationships in the Model View

A new table is useless until you tell Power BI how it relates to your other data. You do this in the Model view.

• Click the Model icon on the left-hand rail (it looks like three connected boxes).
• You'll see a diagram of all the tables in your report. Find your new table.
• Identify a column in your new table that can link it to an existing table. This is often an ID, a date, or a product name. For example, you might have a 'Date' column in both your new Google Analytics data and your existing Shopify sales data.
• Click and drag the key column from one table and drop it directly onto the corresponding key column in the other table.

Power BI will draw a line between the two tables, signifying that a relationship now exists. You can now build visuals that use fields from both tables at the same time - for instance, a chart showing website sessions alongside sales revenue by date.

Method 4: Appending Queries to Add Rows

Appending is used when you have two or more tables with the exact same column structure, and you want to stack them on top of each other into one single table. This is very common for historical data - for instance, you have separate Excel files for sales data from 2021, 2022, and 2023.

1. First, use Get Data to load all of the separate tables into Power Query. For example, you might have Sales_2021, Sales_2022, and Sales_2023.
2. Once they are all in Power Query, select the primary table you want to append others to (e.g., Sales_2023).
3. In the Home ribbon of the Power Query Editor, find the Append Queries button. You can either append directly into your selected table or choose Append Queries as New to create a brand new combined table (this is often the safer option).
4. In the Append dialog, choose whether you are combining two tables or three or more tables. Select the tables you want to stack and click OK.

Power Query will combine all the rows from the selected tables into one master table. After that, you can often disable the load for the original individual tables (by right-clicking them and unchecking 'Enable load') so they don't clutter your report view.

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

Method 5: Merging Queries to Add Columns

Merging is Power BI's version of an Excel VLOOKUP or INDEX/MATCH. It allows you to add columns from one table to another by matching values in a common column (a "key"). For example, you have a Sales table with a ProductID but no product name. You can merge it with a Products table that contains product names, categories, and prices.

1. In Power Query, select the table you want to add columns to (the 'left' table, in this case, Sales).
2. From the Home ribbon, click Merge Queries. As with appending, you can choose to perform the merge on the current table or create a new, merged table. Creating a new one is often cleaner.
3. The Merge dialog will appear. Your Sales table is already selected as the first table. Click its ProductID column to select it as the key.
4. In the dropdown below, select the Products table (the 'right' table). Then, click the ProductID column in that table to tell Power Query these are the columns to match.
5. The most important option is the Join Kind. The default, Left Outer, is what you want most of the time (it keeps all rows from the first table (Sales) and pulls in matching information from the second). Click OK.

You'll see a new Products column added to your table with a value of [Table] in every row. Don't panic! Click the expand icon with the two arrows at the top of this new column. Uncheck any columns you don't want to import (like the redundant ProductID), check the ones you do (like Name and Category), and click OK. The new columns will be appended to your table.

Final Thoughts

Power BI provides robust tools to keep your report up-to-date with fresh information. From simple refreshes and integrating new tables, to more advanced techniques like Appending and Merging, you can adapt your reports to an ever-changing data landscape. Mastering these processes is essential for turning your reports from static snapshots into living, reliable decision-making assets for your team.