Analistable

How to merge Power BI reports

By the Analistable team · Updated · 5 min read

Power BI has no command that merges two .pbix files. The practical routes are: copy the queries from one file into the other and then copy and paste the visuals across; rebuild both reports on one shared semantic model; or leave the reports separate and present them together in a Power BI app or dashboard. Which to pick depends on whether you need one data model or just one place to look.

Part of our guide: How to merge data in Power BI, Power Query and Tableau

Decide what “merge” means

Three different goals
GoalBest routeData model
One report file with both sets of pagesCopy queries, then copy visualsOne combined model
Several reports on the same numbersShared semantic modelOne model, many thin reports
One place for users to browsePower BI app or dashboardModels stay separate

If the two reports use different data that never needs to be compared in one visual, an app is usually enough and is far less work. If users want a chart that mixes figures from both, you need one model.

Route 1: move everything into one .pbix

  1. Open report A (the one you'll keep) and report B in two Power BI Desktop windows.
  2. In B, open Transform data, select its queries in the Queries pane and copy them (Ctrl+C). In A's Power Query editor, paste. The M code comes across; you may need to re-enter credentials.
  3. Close and apply, then recreate relationships between the new tables and A's tables in Model view.
  4. Copy B's measures. There is no bulk copy of measures in the standard UI, so either retype them, use the DAX query view where available, or use a community tool such as Tabular Editor.
  5. In B's report view, select visuals and copy them; paste them on new pages in A. Visuals keep their formatting and bind to fields with the same table and column names.

Pasted visuals show errors where a field name differs between the files. Renaming the table or column in A to match B, or rebinding the field in the Visualizations pane, fixes them. Bookmarks, drill-through pages and some page-level settings need to be recreated by hand.

When both reports load the same source tables, don't paste duplicates. Keep one copy of each table and append or merge where the data overlaps; see merging tables in Power BI and Append Queries.

Route 2: one shared semantic model

Publish one file that holds the data model (often with no report pages), then build each report in a separate file connected to it through Get data → Power BI semantic models. These thin reports share one refresh, one set of measures and one security setup. To merge two existing reports this way, first combine their models as in Route 1, publish the model, then rebind each report to it.

  • Measures live once, so “Revenue” means the same in every report.
  • Refresh happens once instead of once per report.
  • Report authors can add report-level measures but cannot change the shared tables.

Route 3: present reports together

If the aim is one link for the audience, publish an app from the workspace. An app gathers several reports (and dashboards) under one navigation pane, and you control the order and which audiences see what. A dashboard is another option: pin visuals from different reports onto one canvas. Each tile still links back to its source report, and the reports keep their own models.

A worked example: two regional reports

Two analysts built separate sales reports for UK and Ireland. Each has a Sales table and a Products table. The finance lead wants one report with a total across both.

Before and after combining the models
ItemUK reportIreland reportCombined report
Sales rows482001175059950
Products table rows124012401240
Revenue measure£3.10m£0.84m£3.94m
Pages437

Both Sales tables were appended into one with a Country column, the identical Products tables were kept once, and the Ireland pages were pasted into the UK file. The Revenue measure needed currency conversion for the Ireland rows, which is the sort of detail an automatic merge would get wrong. Check that the combined total equals the sum of the two reports before sharing.

Limits to plan around

  • Row-level security roles must be recreated in the combined model.
  • Custom visuals must be imported into the target file before pasted visuals render.
  • Live-connected reports cannot simply absorb another model's tables without converting to a composite model, which has its own limitations.
  • Some features behave differently across Power BI Desktop versions, so test in the version your organisation deploys.

If what you really need is answers across the underlying spreadsheets rather than a merged report, Analistable is a lighter option: load the exported files into your browser and ask cross-sheet questions in plain English. It does not create or edit Power BI reports. The Power BI, Power Query and Tableau guide covers the data-level merges.

Checklist before you share the merged report

  1. Refresh the combined file fully and note the refresh time; two models in one file refresh longer than either did alone.
  2. Compare three or four headline measures with the original reports, at total level and for one filtered slice.
  3. Click through every page and look for visuals showing an error or blank state.
  4. Test slicers that should now filter pages from both reports, and check sync slicers settings.
  5. Check row-level security roles with View as, if the original reports used them.
  6. Republish to a test workspace first, then update the app or links once users have checked it.

Keep the original reports available for a while after the switch. Users will spot differences you missed, and the originals make them easy to investigate.

Frequently asked questions

Can I merge two .pbix files into one?
Not automatically. Copy the queries into one file, recreate relationships and measures, then copy and paste the visuals across.
Can I copy visuals between Power BI reports?
Yes. Copy a visual in one Power BI Desktop window and paste it in another. It works cleanly when the target model has fields with the same names.
How do I show several reports in one place without merging them?
Publish a Power BI app from the workspace, or pin visuals from each report to one dashboard.

Related guides