How to Add More Data to Power BI

You've built your first Power BI dashboard, and things are looking good. But quickly, you realize a single data source only tells part of the story. To get real insights, you need to connect your website analytics with your sales figures, or your ad spend with your CRM data. This article will show you exactly how to add more data to an existing Power BI report, whether it's from a brand new source or just a few extra columns you forgot to pull in.

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

Adding a New Data Source to Your Report

The most common scenario is needing to bring in data from a completely different platform or file. Maybe you started with a Google Analytics export and now you need to add your sales data from a separate Excel file. This process is straightforward and keeps all your data organized within a single report.

Step-by-Step: Connecting to a New Source

Let's walk through the process using a common example: adding a CSV file with detailed customer information to an existing sales report.

1. Open Your Report: Start by opening your existing .pbix file in Power BI Desktop.
2. Find "Get Data": On the Home ribbon at the top of the screen, you'll see a large icon labeled Get Data. Click on this to open a menu of the most common data sources.
3. Select Your Source Type: For our example, we'd select Text/CSV. If you were connecting to a different source, you'd choose accordingly (e.g., Excel Workbook, SQL Server, or click "More..." to find connectors for services like Salesforce or Mailchimp).
4. Locate and Load Your File: Navigate to where your new file is saved and select it. Power BI will then show you a preview of the data. If everything looks correct, click Load.

After clicking "Load," you'll see your new data appear as a distinct table in the Fields pane, which is typically on the right side of your screen. Now you have two separate tables in your report: your original sales data and your new customer data. But there's one more essential step before you can use them together.

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

Connecting the Dots: Managing Data Relationships

Simply loading two tables into Power BI doesn't automatically connect them. Power BI has no idea that the "CustomerID" in your sales table corresponds to the "UserID" in your customer table. You have to tell it how they connect. This is done by creating a relationship between them.

Think of it like having two different contact lists. One has names and phone numbers, and the other has names and email addresses. To see a full profile for any one person, you need to connect the lists using the one piece of information they share: the person's name. In Power BI, this shared info is called a "key."

How to Create a Data Relationship

1. Switch to Model View: On the far left of the Power BI window, click the icon that looks like three connected boxes. This is the Model view, and it gives you a birds-eye view of all the tables in your report.
2. Identify the Common Field: Look at your two tables. Find the column that contains the same information in both. In our example, it might be a column named CustomerID in the sales table and User_ID in the customer info table. Note: The column names don't have to be identical, but the data inside them must match.
3. Drag and Drop to Create the Link: Click and hold the CustomerID column from the sales table. Drag your cursor over to the User_ID column in the customer info table and release the mouse button.

A line will appear connecting the two tables. This line is the relationship! Now, when you create a chart, you can pull the customer's name from one table and their total sales from the other, and Power BI will know exactly how to match them up. Filtering by a customer's name will correctly filter their sales figures, and vice versa.

Bringing in More Data from an Existing Connection

Sometimes you don't need a brand new source, you just need to grab more information from a source you've already connected. Perhaps you connected to a database and only selected the "Sales" table, but now you realize you also need the "Products" and "Regions" tables from that same database.

Trying to go through "Get Data" again will just create a duplicate connection. Instead, you need to edit the original query.

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

How to Edit an Existing Data Source

1. Open the Power Query Editor: On the Home ribbon, click the Transform data button. This will launch a new window called the Power Query Editor, which is where all the behind-the-scenes data preparation happens.
2. Find the "Source" Step: In the Power Query Editor, look for the Applied Steps panel on the right. Every action you've performed on this data (like removing columns or changing types) is listed here. Click on the very first step, which is usually named Source.
3. Click the Gear Icon: Next to the "Source" step, you'll see a small gear icon ⚙️. Click it. This re-opens the "Navigator" window—the same one you saw when you first connected to the data.
4. Select Your Additional Data: From here, you can now tick the boxes for the additional tables or sheets you need (like "Products" and "Regions"). Click OK.
5. Close & Apply: Your new tables will now appear in the list of queries on the left of the Power Query Editor. Once you're done, click the Close & Apply button in the top-left corner to save your changes and load the new data into your report.

Remember, if you add new tables, you'll probably need to go to the Model View to set up relationships between them and your existing tables.

Combining Data: The Power of Appending vs. Merging

For more advanced scenarios, Power BI offers two powerful ways to combine data directly in the Power Query Editor: appending and merging. Understanding the difference is super helpful.

Appending Queries (Stacking Data)

Appending is like stacking multiple spreadsheets on top of one another. You use this when you have multiple files or tables with the exact same columns but different rows of data. A classic example is combining monthly sales reports into a single, comprehensive table for year-to-date analysis.

• When to use it: You have Sales_January.csv, Sales_February.csv, and Sales_March.csv. You append them to create one master Sales_YTD table.
• Where to find it: In Power Query, go to the Home tab and click Append Queries.

Merging Queries (Joining Data Side-by-Side)

Merging is Power BI's version of a VLOOKUP or INDEX/MATCH in Excel. It joins two tables side-by-side based on a common column. This allows you to enrich one table with descriptive information from another.

• When to use it: You have one table with ProductID and Quantity_Sold. You have another table with ProductID, ProductName, and Product_Category. You merge them to bring the product name and category into your main sales table, allowing you to analyze sales by category.
• Where to find it: In Power Query, go to the Home tab and click Merge Queries.

Both tools are fundamental for building sophisticated reports that draw connections between different facets of your business.

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

Best Practices for a Tidy Data Model

As you add more data, your report file can become slow and confusing if you're not careful. Here are a few simple habits to keep your data model clean and efficient:

• Only load what you need: If a table has 100 columns but you only need 10 for your analysis, remove the other 90 in the Power Query Editor using the "Choose Columns" feature. Fewer columns mean a faster, more responsive report.
• Use descriptive names: By default, tables might have names like Sheet1 or tbl_d_crm_contacts. Right-click and rename them in the Queries pane to something intuitive like Sales Data or Customer Contacts. This makes the Fields pane much easier to navigate.
• Check your data types: Power BI is pretty good at guessing data types, but it's not foolproof. Double-check in Power Query that columns containing dates are set to the "Date" type, and numerical columns are set to "Decimal Number" or "Whole Number." Incorrect data types can cause calculation errors and broken visuals.
• Hide unnecessary fields: Some columns, like CustomerID, are essential for creating relationships but aren't something you'd ever put directly into a chart. In the Model view, you can right-click these columns and select "Hide in report view." This will de-clutter your Fields pane without deleting the data.

Final Thoughts

Building a quality dashboard is an iterative process. You start with one source, uncover insights, ask new questions, and inevitably need to pull in more data to get deeper answers. By mastering how to add new data sources, manage relationships, and refine existing connections, you can build truly comprehensive reports that give you a complete view of your business performance.

While mastering these techniques in Power BI is a powerful skill, managing connections across multiple marketing and sales platforms can still feel like a constant battle of juggling different logins and building reports from scratch. We built Graphed to streamline this entire process. Instead of manually connecting each source one by one, you just link your accounts like Google Analytics, Shopify, or Salesforce, then describe the dashboard you want in plain English. Our AI-powered analyst builds it in seconds, pulling live data from all your sources and finding the connections for you, turning hours of report building into a 30-second conversation.