How to Merge Two Power BI Dashboards

Working with multiple Power BI dashboards can feel like juggling separate reports when you just want to see the whole story in one place. If you've ever found yourself wishing you could combine two or more reports into a single, unified view, you’re in the right place. This guide will walk you through several practical methods to merge your Power BI reports and dashboards, from simple pinning techniques to more powerful data consolidation strategies.

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, Let's Clarify: Report vs. Dashboard

In the world of Power BI, the terms "report" and "dashboard" have specific meanings, though they’re often used interchangeably. Understanding the difference is the first step to figuring out the best way to merge your content.

• A Power BI Report is a multi-page file where you design and build your data visualizations. It's an interactive canvas connected to a single dataset where you explore your data.
• A Power BI Dashboard is a single-page canvas in the Power BI service that uses "tiles" to display visuals pinned from one or more reports. Dashboards are meant to give a quick, high-level overview.

Most of the time, when people ask to "merge dashboards," they are really trying to combine visuals from multiple reports into a single, consolidated view. We'll cover how to do just that, as well as how to merge the underlying data powering those reports for a truly unified analysis.

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 1: Create a Central Dashboard by Pinning Visuals

The most straightforward method for combining visuals from different reports is by creating a new, central dashboard in the Power BI Service. This approach works by "pinning" a live-updating tile of an individual visualization from a report directly onto a dashboard. You can pull in visuals from any number of reports as long as you have access to them.

Step-by-Step Guide to Pinning Visuals:

Let's say you have two reports: a "Marketing Analytics" report and a "Sales Performance" report, and you want to see key visuals from both on one screen.

1. Open Your First Report: In the Power BI Service (app.powerbi.com), navigate to your workspace and open the "Marketing Analytics" report.
2. Choose and Pin a Visual: Hover over a visual you want to display on your new dashboard, like a chart showing "Website Sessions by Channel." A small pin icon will appear. Click it.
3. Create the New Dashboard: A dialog box will pop up. Select "New dashboard" and give it a name, for example, "Executive Business Overview." Click "Pin live." Power BI will create the dashboard and add your visual to it.
4. Open Your Second Report: Now, navigate to your "Sales Performance" report.
5. Pin from the Second Report: Find the visual you want, such as "Revenue by Sales Rep," and click the pin icon just as you did before.
6. Pin to the Existing Dashboard: This time, in the dialog box, select "Existing dashboard." Make sure your "Executive Business Overview" dashboard is selected from the dropdown menu and click "Pin live."
7. Review and Organize: Go to your new dashboard. You’ll now see tiles from both your marketing and sales reports. You can freely resize and rearrange these tiles to create your perfect overview.

When to use this method: This is a great solution for creating a high-level, at-a-glance view of essential metrics that are spread across different reports and datasets.

Method 2: Combine Data Sources with Power Query

Sometimes, creating separate reports is a symptom of a larger problem: your data lives in different files or systems. Instead of combining visuals at the end, a more robust solution is to combine the raw data at the beginning using Power Query Editor in Power BI Desktop.

By merging the underlying datasets, you can build a single, comprehensive report that contains all your information from the start.

In Power Query, there are two primary ways to combine data: Merging and 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

Appending Queries

Appending is like stacking tables with identical columns on top of each other. This is perfect when you have data separated by time period (e.g., separate sales CSVs for January, February, and March) or by region (sales data for USA and Europe).

How to Append Data:

1. Open your Power BI report and click on "Transform data" to open the Power Query Editor.
2. Make sure your separate tables (e.g., Sales_Jan, Sales_Feb) are loaded into the editor.
3. On the Home ribbon, click the dropdown for "Append Queries" and choose "Append Queries as New."
4. Select the tables you want to stack. If you have two, add them to the selection. If you have three or more, select that option and add them to the list.
5. Click OK. Power BI will create a new, consolidated table with all the rows from your selected tables combined.

You can then build your visuals using this new, complete master table.

Merging Queries

Merging is like a VLOOKUP in Excel but way more powerful. It combines two tables side-by-side based on a shared column (a key). This is useful when you have related data in different tables, such as sales transaction data in one table and customer details in another.

How to Merge Data:

1. With the Power Query Editor open, select the primary table you want to add columns to (e.g., your Sales table).
2. On the Home ribbon, click "Merge Queries."
3. In the Merge window, select the second table you want to pull data from (e.g., your Customers table).
4. Click on the matching column in each table preview. For this example, that might be "CustomerID."
5. Choose the right "Join Kind." An "Inner" join will only keep rows that match in both tables, while a "Left Outer" join (the most common) will keep all rows from the first table and add matched data from the second.
6. Click OK. A new column will appear in your Sales table. Click the expand icon in the header of this new column to select which fields from the Customers table (like city or name) you want to add.

When to use this method: This is the best approach when your goal is true data consolidation. It’s cleaner, more scalable, and allows for deeper analysis than simply pinning visuals from siloed reports.

Method 3: Build a Master Report with Page Navigation

If combining datasets isn't feasible but pinning visuals on a dashboard feels too limited, you can create the feel of a single, merged destination inside one Power BI report. The strategy is to design a "landing page" or "home page" that acts as a navigation hub to different pages, each representing one of your original reports.

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

Steps to Create a Navigation Hub:

1. Copy Pages to a Single Report: Open two instances of Power BI Desktop. In one, have your first report, and in the other, your second. You can simply right-click on a report page tab in one file and select "Copy Page." Then, move to your destination report file and right-click in the page tab area to paste it. Replicate the needed data sources and relationships for the copied pages.
2. Create a Landing Page: Add a new page at the beginning of your report and name it "Home" or "Overview."
3. Add Navigation Buttons: On your Home page, go to the "Insert" ribbon and add "Buttons." You can use a blank button and add text to it. Create a button for each major section or report page, such as "View Marketing Funnel" and "View Sales Pipeline."
4. Configure the Actions: Select a button. In the "Format" pane, turn on the "Action" toggle. Set the "Type" to "Page navigation" and for the "Destination," select the report page you want the button to link to.
5. Add "Back" Buttons: On each subsequent page, add a "Back" button and set its action to navigate back to your "Home" page for a seamless user experience.

This method gives you a cohesive, app-like report that combines the content of several smaller reports into one easy-to-navigate file, while still maintaining the full interactivity that dashboards lack.

Best Practices for Consolidated Dashboards

No matter which method you choose, a poorly organized dashboard can be more confusing than multiple separate ones. Keep these tips in mind:

• Maintain a Consistent Theme: Use a consistent color palette, font, and layout across all visuals. If your Marketing report uses blue and your Sales report uses green, your merged dashboard will look chaotic. Pick a theme and stick to it.
• Focus on a Narrative: Don't just throw charts onto a page. Arrange them logically. A good dashboard tells a story, perhaps moving from high-level summaries on top to more granular details below.
• Watch Performance: The more visuals and data you add, the slower your report can become. Use only the most essential visuals on a summary view and be mindful of complex DAX calculations that might slow down load times.
• Manage Permissions: Remember that users need access to the underlying reports and datasets to see the data on a consolidated dashboard. Ensure you have set the appropriate permissions.

Final Thoughts

Merging Power BI dashboards is less about a single button-click and more about choosing the right strategic approach. Whether you're pinning visuals to create a summary dashboard, unifying your underlying data models, or building an interactive master report with clever navigation, you can create a single source of truth that tells your complete business story.

If all this manual configuration in Power BI feels tedious, you might find our approach at Graphed to be more efficient. We connect directly to your data sources like Google Analytics, Shopify, and Salesforce, allowing you to create unified, real-time dashboards in seconds just by describing what you want in plain English. This can save you hours of work pulling data and building reports, allowing you to focus on the insights instead.