Graphed LogoGraphed
Graphed LogoGraphed
How It WorksAgentsIntegrationsPricing

How to Merge Two Power BI Reports into One

Cody Schneider••7 min read

Trying to merge two Power BI reports into one can feel like trying to solve a puzzle with no picture on the box. You have two perfectly good reports, each with valuable data and visuals, but you need them to work together in a single, unified view. We'll walk through the practical methods for combining your reports, from a quick copy-and-paste to building a more robust, scalable solution.

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

Why Merge Power BI Reports in the First Place?

Before diving into the "how," let's quickly touch on the "why." Combining reports isn't just about reducing the number of files you have to manage. It delivers several clear benefits:

  • Create a Single Source of Truth: When sales data lives in one report and marketing data in another, it’s tough to get a clear picture of performance. Merging them lets you build a comprehensive dashboard that tracks the entire customer journey, from campaign impression to closed deal.
  • Enable Holistic Analysis: How does website traffic from a specific blog post affect product sales? How does customer support ticket volume correlate with return rates? Answering these cross-functional questions is nearly impossible with siloed reports but becomes straightforward with a merged data model.
  • Simplify the User Experience: Instead of making stakeholders and team members open multiple reports to find answers, you can provide a single, easy-to-navigate file. This reduces confusion and encourages more people to use the data to make decisions.

Understanding the Core Challenge: What's in a .pbix File?

Power BI doesn’t have a simple “Merge Reports” button because a .pbix file is more than just a collection of charts. It’s a self-contained package containing three key components:

  1. The Data Model: This is the relational backbone of your report, containing your data tables, the relationships between them, and your DAX measures.
  2. The Power Query Transformations: These are all the data cleaning and preparation steps you've configured in the Power Query Editor.
  3. The Report Canvas: This is the front-end layer with all your visual elements like charts, graphs, slicers, and text boxes.

When you "merge" two reports, you’re really merging these three components. With that context, let's explore the best ways to do it.

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.

Method 1: The Quick Copy-and-Paste (For Simple Cases)

The fastest way to get visuals from one report into another is by simply copying and pasting them. While this sounds easy, Power BI does some interesting things behind the scenes that you need to be aware of.

This method works best when the reports have distinct data sources or you only need to move a few visuals without building a complex, integrated data model.

Step-by-Step Guide:

  1. Open Both Reports: Launch Power BI Desktop and open both .pbix files — your "source" report (where the visuals are now) and your "destination" report (where you want them to end up).
  2. Select and Copy Visuals: In the source report, navigate to the page with the visual you want to move. Click on the visual to select it. To select multiple visuals, hold down the Ctrl key while clicking. Once selected, press Ctrl+C to copy them.
  3. Paste into the Destination Report: Switch over to your destination report. Create a new page or go to an existing one. Press Ctrl+V to paste the visuals.

What Happens Next (The Important Part)

When you paste the visual, Power BI doesn’t just copy the chart, it also brings over an entire copy of the underlying data needed to power that chart. This includes the Power Query transformations, the data tables, and any measures used in the visual.

Potential Issues and How to Fix Them:

  • Duplicate Queries and Tables: If your original two reports pulled data from the same source (e.g., both used Google Analytics), you will now have two sets of Google Analytics queries and tables in your destination report. You'll need to open the Power Query Editor (click "Transform data") and delete the duplicate queries to avoid confusion and data bloat.
  • Broken Visuals: The pasted visual might show an error. This usually happens if the data fields it needs were not copied over correctly or if their names conflict with existing fields. Simply select the broken visual and drag the correct fields from your Fields pane onto the visual’s configuration settings to fix it.
  • Messed-Up Relationships: If new tables were brought over, they won't automatically have relationships with the existing tables in your model. Go to the Model view to see your tables. Drag fields between the new and old tables (like a 'Date' or 'ProductID' column) to establish the relationships needed for your visuals to interact correctly.
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

Method 2: Shared Datasets (The Scalable, Best-Practice Approach)

For more complex scenarios, relying on copy-paste will create a messy, unmanageable file. A much cleaner and more professional approach is to consolidate your data into a single, master data model, publish it as a "shared dataset," and then build your new, combined report on top of it. This separates your data layer from your presentation layer.

Part A: Consolidate Your Data Model

The goal here is to create a single .pbix file that contains all the queries and tables from both of your original reports.

  1. Choose a Primary File: Open the report that has the more complete or fundamental data model. We'll use this as our base and add data from the second report to it.
  2. Bring Over Power Query Scripts: With your base report open, click "Transform data" to open the Power Query Editor. Now, open a second instance of Power BI Desktop with your second report and open its Power Query Editor as well.
  3. Copy Power Query Code: For each query you need to move from the second report, right-click it, select "Advanced Editor," and copy the entire M code script.
  4. Add New Query in Primary Report: In your primary report's Power Query Editor, select "New Source" > "Blank Query." Right-click the new query, open its "Advanced Editor," and paste the M code you copied. Rename the query to something meaningful.
  5. Repeat and Apply: Repeat for all necessary queries. Once done, click "Close & Apply."
  6. Create Relationships: Switch to the Model view. Your existing tables and new ones will be present. Drag fields to create relationships (e.g., connect date fields across tables). Aim for a cohesive, interconnected data model.
  7. Clean and Finalize: Add necessary DAX measures, hide unneeded columns, set data types. Save this comprehensive .pbix file.

Part B: Publish the Dataset and Rebuild the Report

  1. Publish the Dataset: In your consolidated .pbix, click "Publish" on the Home ribbon and select a workspace. This uploads both a report and dataset to Power BI Service.
  2. Connect to the Shared Dataset: Open a blank Power BI Desktop. On the Home ribbon, click "Get Data," then choose "Power BI datasets."
  3. Select Your Dataset: Pick the published dataset and click "Create." Now, your file is live connected to the master data.
  4. Reuse Visuals: You can copy visuals from other reports and paste them into this new file. The visuals will connect to the centralized dataset, ensuring consistency and minimizing errors.

This method centralizes your data management, making future updates much easier.

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.

Advanced Option: Centralizing with Power BI Dataflows

If you work in a larger organization or want higher reusability, consider Power BI Dataflows. A Dataflow is "Power Query in the cloud," allowing data transformation and cleaning outside of a .pbix file.

  • Create a new Dataflow in Power BI Service.
  • Recreate necessary queries and transformations as separate tables within the Dataflow.
  • Connect multiple reports directly to this Dataflow as a clean, standardized data source.

Dataflows are excellent for enforcing consistent business logic and sharing data structures across teams.

Final Thoughts

Combining two Power BI reports is a common challenge, and the right approach depends on your needs. For quick, simple merges, copying and pasting visuals works if you’re careful about data dependencies. For scalable, long-term solutions, creating a consolidated shared dataset is the best practice—separating your data model from your reports.

While mastering these techniques is valuable, sometimes manual data consolidation and modeling are the most time-consuming parts. At Graphed, we handle this for you: connect your sources (Google Analytics, Shopify, Salesforce, etc.) once, and receive a real-time, unified dashboard built automatically. Focus on insights, while we manage data prep.

Related Articles