Graphed LogoGraphed
Graphed LogoGraphed
How It WorksAgentsIntegrationsPricing

How to Copy Power BI Tab from One Report to Another

Cody Schneider••8 min read

You’ve spent hours perfecting a dashboard page in a Power BI report - the visuals are aligned, the DAX measures are running flawlessly, and the filters tell a clear story. Now, you need that exact same page in another report, but dragging and dropping the .pbix file tab doesn't work. This article will show you exactly how to copy a Power BI tab from one report file to another using a few different methods, from the surprisingly simple to the impressively technical.

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 Can't You Just Copy-Paste a Power BI Tab?

Before we jump into the "how," it's helpful to understand the "why." A Power BI report page isn't just a static collection of charts and tables like in a PowerPoint slide. Every single visual on the page is directly connected to the report's underlying data model. This model includes:

  • Your data tables (from Excel, SQL, etc.).
  • The relationships between those tables.
  • Any DAX measures you've written (like Total Sales or Year-over-Year Growth).
  • The queries you built in Power Query to clean and transform the data.

When you try to copy a page, Power BI needs to know how to connect the visuals on that page to the data model in the new, destination report. If the new report doesn't have the exact same tables, column names, and measures, the visuals will simply break. This deep dependency on the data model is why there isn't a straightforward "Duplicate Page to Another Report" button.

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: Copy-Pasting Live Visuals

The most direct method is to copy the visuals off one page and paste them onto a page in your other report. This works best when both the source and destination reports are connected to the exact same (or very similarly structured) data model.

Here's how to do it step-by-step:

  1. Open Both Reports: Launch Power BI Desktop and open both the source report (the one with the page you want to copy) and the destination report (the one you want to copy it to).
  2. Go to the Source Page: In the source report, navigate to the specific page you want to copy.
  3. Select All Visuals: The easiest way to do this is to click on a blank part of the report canvas and press Ctrl + A on your keyboard. This will select every visual, slicer, and text box on the page.
  4. Copy the Visuals: With everything selected, press Ctrl + C to copy them all to your clipboard.
  5. Create a New Page in the Destination: Switch over to your destination Power BI report. Click the small "+" icon at the bottom of the screen to add a new, blank page.
  6. Paste the Visuals: Click anywhere on the blank canvas of your new page and press Ctrl + V.

Power BI will now paste all the visuals onto your new page, attempting to maintain their original layout and formatting. Your theme settings in the destination report will be applied.

The Important "Gotchas" of This Method

This method sounds simple, but its success depends entirely on your data models. Here's what to watch out for:

  • Must Have Identical Data Structures: For the visuals to work instantly, the destination report must contain tables, columns, and measures with the exact same names as those used in the source report's visuals. If you copied a chart based on a measure called [Total Revenue], the new report must also have a measure with that exact name.
  • DAX Measures Are Not Copied: Copying a visual that relies on a DAX measure will not automatically copy the measure's code into the destination file. You must copy the DAX formula for each required measure separately and create them in the destination report before you paste the visuals. A common workflow is to open the DAX formulas in the source report, copy the text to a notepad, then create them one-by-one in the new report.
  • Filters and Interactions Need Re-Checking: Page-level filters will need to be reapplied manually. It’s also a good idea to click through your visuals to ensure their cross-filtering interactions were carried over 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: Save as a Template (.pbit)

If your goal is to standardize a report format to be used with the same data source over and over again, using a Power BI Template file (.pbit) is a much more robust approach. A template file saves the entire report structure - all pages, visuals, the data model, and themes - without the data itself.

This is perfect for situations like creating monthly performance reports where the structure stays the same, but the data is refreshed each month.

  1. Open the Source Report: Open the .pbix file that has the page layout you want to reuse.
  2. Export as a Template: Go to the menu and select File > Export > Power BI template.
  3. Add a Description: A dialog box will pop up asking for a template description. It's good practice to briefly describe what the template is for.
  4. Save the .pbit File: Save the template file in a memorable location.
  5. Use the Template to Create a New Report: To use your template, simply double-click the .pbit file you just saved. Power BI will open it as a new, untitled report and immediately prompt you to connect to the required data sources.

After you configure the data sources and load the data, you'll have a brand new .pbix report with all the pages from your original file. You can then just delete the pages you don't need, leaving you with a perfect copy of the one you wanted.

Method 3: The Advanced "Unpack and Repack" Technique

For more advanced users who feel comfortable going under the hood, there is a powerful but unsupported method: editing the report layout file directly. A .pbix file is actually just a special type of zip file in disguise.

Disclaimer: This is an advanced technique. Always create backups of your .pbix files before attempting this, as you can easily corrupt a report if a step is done incorrectly.

  1. Create Backups: Make a copy of both your source and destination .pbix files. Work only with the copies.
  2. Rename to .zip: Change the file extension on both copies from .pbix to .zip. (For example, MySourceReport_copy.pbix becomes MySourceReport_copy.zip). You may need to enable "show file extensions" in your Windows settings.
  3. Extract the Files: Extract the contents of both .zip files into two separate folders. Let's call them "SourceFolder" and "DestinationFolder".
  4. Find the Layout File: Inside each extracted folder, navigate to the \Report\ subdirectory. In here, you will find a file named Layout. This is a JSON file that defines every element on every page of your report.
  5. Identify the Page JSON: Open the Layout file from your "SourceFolder" using a code editor like VS Code or even Notepad++. Search for the name of the page you want to copy as it appears on the tab in Power BI (e.g., "Sales Summary"). You will find it in a property called displayName. This is part of a larger JSON object that represents your entire page. Carefully select and copy this entire page object, from its opening curly bracket { to its closing curly bracket }.
  6. Add the Page to the Destination: Now open the Layout file from your "DestinationFolder." You'll see a structure that includes a JSON array called "sections". Each object inside this array is a report page. Go to the end of the sections list, add a comma after the last page's closing bracket, and paste the page JSON object you copied in the previous step. Validate that your JSON is still correct (no missing or extra commas!).
  7. Save and Repack: Save the modified Layout file. Now, go back to your "DestinationFolder," select all the files and folders inside it, right-click, and "Send to > Compressed (zipped) folder."
  8. Rename back to .pbix: Finally, rename your new .zip file's extension from .zip back to .pbix. Open it in Power BI, and you should now see your newly added page!

Like the first method, this still relies on the destination report having the same data model and measures to work correctly. However, it's a very clean way to transfer an entire, complex page layout in one move.

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.

Final Thoughts

While Power BI doesn't offer a one-click button to copy pages between reports, you can get the job done by copy-pasting visuals directly or by leveraging report templates for standardized builds. For those needing to transfer intricate layouts, exploring the contents of the .pbix file itself offers a powerful, albeit risky, alternative. The key takeaway is that the visuals are only half the story, successful copying always depends on a matching data model in the destination file.

The time spent manually wrangling data, rebuilding dashboards in different tools, and hacking report files is exactly what we set out to eliminate. Instead of spending hours wrestling with complex desktop applications, we created Graphed to help marketers and sales teams get answers in seconds. You can connect all your sources - from Google Analytics and Shopify to your ads platforms - and build the live dashboards you need just by describing them in plain English, allowing you to focus on an insight instead of a configuration screen.

Related Articles