How to Duplicate a Report in Power BI

Duplicating a report in Power BI is a fundamental skill that saves a massive amount of time, whether you're experimenting with new visuals or creating different versions for specific audiences. Rather than starting from scratch, you can leverage an existing report as a powerful template. This article will show you the exact steps for duplicating reports in both Power BI Desktop and the Power BI Service, and we'll cover the best scenarios for each method.

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

Why Duplicate a Report in Power BI?

Before diving into the "how," let's quickly cover the "why." Understanding the common reasons for duplicating a report helps you choose the right method for your goal.

• Creating Variations for Different Audiences: Your executive team might only want to see high-level Key Performance Indicators (KPIs), while your marketing team needs to drill down into campaign-specific metrics. Duplicating a base report allows you to tailor copies for each stakeholder without rebuilding the core data connections and measures each time.
• Testing and Development: Want to try a new chart type, write a complex DAX measure, or completely redesign the layout without jeopardizing your live, production-ready report? A duplicate report acts as a safe 'sandbox' where you can experiment freely. If you make a mistake, the original remains untouched.
• Archiving and Version Control: Before making significant changes to a critical report, creating a copy is a simple yet effective way to create a backup. You can name it something like "Sales_Dashboard_v1.0" for versioning. If your changes don't work out, you can easily revert to the previous version.
• Building Report Templates: Many organizations have standard reporting templates that must include the company logo, specific color themes, and a common set of DAX measures. You can build one "master" Power BI file and then use the duplicate function to kickstart any new report, ensuring consistency and saving setup time on every project.

Method 1: The "Save As" Technique in Power BI Desktop

This is the most common and straightforward way to create a complete, independent copy of a Power BI report. If you want a brand-new .pbix file that is an exact replica of your original, this is the method to use.

Who This Method Is For:

This approach is perfect for BI analysts, data specialists, and anyone building reports in Power BI Desktop who needs a completely separate file to work on. It's the go-to method for creating development versions, templates, or distinct copies for different departments.

Step-by-Step Instructions:

1. Open Your Original Report

First, launch Power BI Desktop and open the .pbix file of the report you want to copy. Make sure you're starting with the correct version you intend to duplicate.

2. Navigate to the File Menu

In the top-left corner of the Power BI Desktop window, click on the File tab to open the main menu.

3. Select "Save As"

From the File menu, choose the Save As option. This will open a file dialog box, similar to how you would save a new document in Microsoft Word or Excel. It's important to choose "Save As" and not "Save," as "Save" will just overwrite your existing report with any changes.

4. Choose a New Name and Location

In the dialog box, give your duplicated report a new, descriptive name. This is where a clear naming convention comes in handy. For example, you might change Monthly Sales Report.pbix to Monthly Sales Report - Executive View.pbix or Monthly Sales Report - TEST.pbix.

You can also save it to a different folder to keep your projects organized. Once you've chosen the name and location, click the Save button.

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

What Gets Duplicated?

Using "Save As" creates a full clone of the original .pbix file. This means everything inside is copied over:

• All report pages and visuals
• The complete data model, including tables, columns, and relationships
• All Power Query transformations
• All of your DAX measures and calculated columns
• Your report theme, including colors and fonts
• Bookmarks, filters, and slicer settings

The new file is completely independent. Any changes you make to this copy — whether it's altering a visual or updating a measure — will not affect the original report, and vice versa.

Method 2: Duplicating a Page Within the Same Report

Sometimes you don't need a whole new file, you just need a new page within your existing report that acts as a starting point. For example, you may want to create a "Dashboard V2" page to test a new design without deleting your original dashboard on "Page 1."

Who This Method Is For:

This method is ideal when you need to create slightly different views of the same data model. It's perfect for building out a single report that serves multiple purposes, such as having one page for "Sales Overview" and a duplicated, slightly modified page for "Regional Sales Deep Dive."

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 Instructions:

1. Go to the Page You Want to Copy

Below your report canvas in Power BI Desktop, you’ll see tabs for each page. Click on the tab of the page you wish to duplicate.

2. Right-Click and Duplicate

Right-click on the page tab to open a context menu. From this menu, select Duplicate Page. Power BI will instantly create an exact copy of that page, named something like "Copy of Page 1," and place it as a new tab next to the original.

This new page will have every single visual, slicer, image, and text box from the original page already in place.

3. Rename the New Page (Recommended!)

It's always a good practice to rename the duplicated page. Right-click on the new page tab, select Rename Page, and give it a more meaningful name that reflects its purpose. This keeps your report organized and easy for others to navigate.

Key Difference From "Save As"

The crucial thing to understand here is that this new page shares the exact same underlying data model and DAX measures as every other page in the report. If you edit a DAX measure, it changes on all pages that use it. If you add a new column in the Power Query Editor, it becomes available across the entire report. You're creating a new canvas for visuals, but not a new data backend.

Method 3: Copying a Report in the Power BI Service

What if the report has already been published to the cloud-based Power BI Service? You can still create a copy without having to download the .pbix file first. This is very useful for creating quick variations directly in your workspace.

Who This Method Is For:

This method is for users who are viewing or working on reports in their web browser within a Power BI workspace. It's the equivalent of "Save As" but for the online service.

Step-by-Step Instructions:

1. Navigate to Your Workspace

Log in to your Power BI account at app.powerbi.com and navigate to the workspace where the report is located.

2. Find Your Report and Open the Menu

In the list of content within the workspace, find the report you want to duplicate. You don't need to open the report itself. Hover over the report name and click on the more options ellipsis (...).

3. Select "Save a copy"

From the dropdown menu, click on Save a copy.

4. Provide a New Name

A dialog box will appear, prompting you to enter a name for the copied report. Enter a new name and click Save. Power BI will create the new report copy within the same workspace.

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

Important Note on Datasets

When you copy a report in the Power BI Service, the new report is automatically connected to the same published dataset as the original report. It does not create a new, separate dataset. This is excellent for consistency, as any data refresh scheduled for the original dataset will automatically flow through to your newly copied report. However, it also means that to change the data model or DAX measures, you eventually have to edit the original .pbix file and republish it.

Best Practices for Managing Duplicated Reports

Simply knowing how to duplicate reports is one thing, but managing them effectively is what separates a clean workspace from a cluttered one.

• Use a Clear Naming Convention: Avoid confusion by being methodical with your file names. Append suffixes like _DEV, _Live, _Archived, or _SME-Review to clarify the purpose and status of each report copy. This makes it instantly clear which file is which.
• Be Mindful of Your Data Sources: Remember that a duplicated .pbix file created with "Save As" still points to the very same data sources (SQL server, Excel files, SharePoint lists, etc.). When you refresh either report, they will both pull the latest data from those sources.
• Document Your Major Changes: If you use a duplicate report for development, it can be helpful to add a hidden text box on the canvas or a separate "Changelog" page where you briefly list the modifications made. This can be a lifesaver months later when you or a colleague needs to understand what is different between versions.

Final Thoughts

Learning how to duplicate a report in Power BI is all about working smarter, not harder. Whether you use "Save As" for a completely new file, duplicate a page for a new internal view, or "Save a copy" in the service for a quick online variant, you are saving yourself from the repetitive work of rebuilding reports from the ground up.

Creating and managing different versions of a report in a tool like Power BI takes time and careful attention to detail. At Graphed, we’ve focused on simplifying this entire process of creating dashboards and reports from the start. Instead of manually duplicating, reconfiguring visuals, and managing multiple files, our platform lets you build dashboards and ask questions using natural language. Want a different view of your sales data for the executive team? Just ask for it, and the report is generated in seconds, streamlining a process that could otherwise take hours.