How to Make a Copy of a Power BI Report

Duplicating a report in Power BI is a great way to create a new version for a different audience or to experiment with changes without risking your original work. This article shows you several easy ways to copy your existing reports, whether you're working locally in Power BI Desktop or online in the Power BI service.

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 Copy a Power BI Report?

Before jumping into the "how," it's helpful to understand the "why." While it seems simple, copying reports serves several important purposes that can make your analytics workflow much smoother and safer.

• Experiment Safely: Want to try out a new color scheme, add a different type of visual, or test a complex new DAX measure? Making a copy gives you a sandbox where you can experiment freely without messing up a report that your team relies on.
• Create Templates: If you have a standard report layout you love, you can save a copy of it as a starter template. The next time you need to build a similar analysis, you just open the template, connect a new data source, and you're good to go.
• Tailor Reports for Different Audiences: The executive team might need a high-level overview, while the marketing department needs to see granular campaign details. You can copy a single master report and then customize each version for its specific audience without starting from scratch.
• Backup Your Work: Before making significant edits, saving a quick copy is the simplest form of version control and a great way to create a backup. If things go wrong, you can always revert to the saved version.

Method 1: Using "Save as" in Power BI Desktop

This is the most straightforward method and is perfect if you are working with a .pbix file on your computer. This method creates a completely separate, self-contained clone of your report, including the data model, queries, visuals, and imported data.

Think of it as the "Save As" you'd use in Word or Excel. Everything within the file is duplicated into a new, independent file.

Step-by-Step Instructions

1. Open the Power BI report (the .pbix file) that you want to copy using Power BI Desktop.
2. On the top menu, click on File.
3. From the dropdown menu, select Save as.
4. A dialog box will appear. Navigate to the folder where you want to save the copy.
5. Give the file a new name to distinguish it from the original (e.g., "Monthly Sales Report - V2" or "Sales Report - Marketing Team View").
6. Click Save.

That's it. You now have a complete, independent copy of your original report on your computer. You can open this new .pbix file and make any changes you want, and it will have no effect on the original file. When you're ready, you can publish this new version to the Power BI service as a completely new report and dataset.

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 2: Save a Copy in the Power BI Service

If your report is already published to the Power BI service, you can easily create a copy directly in your browser. This method is fast and efficient, but it's important to understand what it's actually copying. When you use this method, you are only duplicating the report pages and visuals, not the underlying dataset.

The new, copied report will be connected to the exact same dataset as the original. This is useful when you want to create multiple views of the same data for different stakeholders.

Understanding the Difference: Report vs. Dataset

• Dataset: This is the data backbone. It contains your tables, relationships, DAX measures, data sources, and refresh settings.
• Report: This is the visualization layer. It's the collection of pages, charts, graphs, tables, and slicers that your end-users interact with.

When you use "Save a copy" in the service, both the original and the new report stay connected to one central dataset. This means if you refresh the data in the dataset, both reports will update. If you add a new DAX measure to the dataset, that measure becomes available in both reports.

Step-by-Step Instructions

1. Open your web browser and navigate to the Power BI service at https://app.powerbi.com.
2. On the left pane, navigate to the Workspace that contains the report you want to copy.
3. Find the report in the content list. Hover over it or click the three vertical dots (More options) to the right of the report name.
4. In the menu that appears, click Save a copy.
5. A dialog box will ask you to name your copied report. Enter a descriptive title.
6. Click Save.

Your new report will instantly appear in the same Workspace. You can now open it and edit the visuals however you like without impacting the original report's layout.

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: Downloading the Report File from the Service

What if the report only exists in the Power BI Service, but you want a complete, independent clone - including a new dataset? This is a common need when you want to branch off a new line of analysis entirely. To do this, you can download the .pbix file from the service and then republish it.

This approach combines the online and desktop environments and is the most reliable way to make a full, detachable clone of a cloud-hosted report.

Step-by-Step Instructions

1. Navigate to the Power BI service and open the report you want to clone.
2. Once the report is open, go to the top menu and select File > Download this file.
3. A dialog box will appear. Select the option "A copy of your report and data (.pbix)" and click Download.
4. Power BI will prepare the file for download. Once it's ready, save the .pbix file to your computer.
5. Now, open that freshly downloaded file in Power BI Desktop. You can rename it and make any edits you need — to the visuals, the queries in Power Query, or the data model.
6. When you're ready, publish it back to the Power BI service. It will be uploaded as a brand-new report accompanied by a brand-new, independent dataset.

Important Considerations

When you publish this newly downloaded and edited report, remember that you'll have to reconfigure the scheduled refresh and data source credentials for the new dataset within the Power BI service's settings.

Method 4: Duplicating an Entire Workspace

Sometimes, copying just one report isn't enough. You might need to duplicate a whole collection of related reports, dashboards, and their underlying datasets. This is incredibly useful for setting up different environments (like a testing area and a production area) or for creating boilerplate content packages for different clients.

Power BI lets you duplicate an entire workspace in just a few clicks.

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

Step-by-Step Instructions

1. From the Power BI service, go to the list of your workspaces.
2. Find the workspace you want to copy, and click the three vertical dots (More options) next to its name.
3. Select Workspace settings from the menu.
4. At the top of the settings pane, click Duplicate workspace.
5. Give the new duplicate workspace a unique name.
6. You'll have an option to include "data in a new copy of the datasets." If you want completely independent reports and data, make sure this option is selected.
7. Click Duplicate.

Power BI will work in the background to copy all the content — dashboards, reports, and datasets — into the new workspace. This creates a fully self-contained environment that mirrors the original but is completely separate from it.

Choosing the Right Method for Your Goal

With several options available, here's a quick cheat sheet to help you decide:

• For a simple, offline backup or a totally separate version of a .pbix file: Use "Save as" in Power BI Desktop.
• To create another visual perspective on an already-published report without duplicating data: Use "Save a copy" in the Power BI service.
• To create a totally independent online report from one that's already published: Use the "Download this file" method.
• To clone an entire project with multiple reports and dashboards for staging or a new client: Use the "Duplicate workspace" feature.

Final Thoughts

Creating copies of your Power BI reports is a fundamental skill for managing your analytics workflow effectively. Whether you're doing a simple 'Save as' for a safe backup, duplicating a report in the service for a new audience, or cloning an entire workspace, these methods allow you to work more flexibly and securely.

While mastering Power BI's features provides great control over your final reports, we know the initial process of getting all your sales and marketing data into one place can still be overwhelming. At Graphed, we aim to eliminate this friction entirely. Our platform allows you to connect to sources like Google Analytics, Shopify, Facebook Ads, and Salesforce in seconds. Instead of wrestling with data models, you can just describe the report you need in simple language - like "Show me a dashboard comparing Facebook spend vs. sales by campaign" - and get a real-time dashboard built for you instantly.