Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Anonymous
Not applicable

Can I combine 2 pbix file into 1 report?

Hi. I have 2 reports with me. Report A has 50 pages, Report B has around 70 pages. Is there a way to combine those two reports into 1? 
I saw this link https://www.inkeysolutions.com/blogs/power-bi-copy-visuals-to-another-pbix-file/ but it seems like I need to copy each pages into another report. Can I just merge the 2 reports to combine them?

1 ACCEPTED SOLUTION
v-luwang-msft
Community Support
Community Support

Hi @Anonymous ,

There is no quick way to combine PBIX files. The update to copy/paste objects between files was released in November 2018: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-november-2018-feature-summary/#copyPaste

 If the pbix files have been ppublished to Power BI Service you can put them in the same workspace and they can share datasets and visuals. There is no similar solution in desktop.

 

 

Wish  it is helpful for you!

 

Best Regard

Lucien Wang

View solution in original post

5 REPLIES 5
v-luwang-msft
Community Support
Community Support

Hi @Anonymous ,

There is no quick way to combine PBIX files. The update to copy/paste objects between files was released in November 2018: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-november-2018-feature-summary/#copyPaste

 If the pbix files have been ppublished to Power BI Service you can put them in the same workspace and they can share datasets and visuals. There is no similar solution in desktop.

 

 

Wish  it is helpful for you!

 

Best Regard

Lucien Wang

Tahreem24
Super User
Super User

@Anonymous  - Another workaround is to copy the report B's published link and then create one button say "Report B" and past the copied link on that button so it will give you entire report B on that button click.

Capture.PNG

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard
Anonymous
Not applicable

@Tahreem24 Hi. Do you know a way if I'm using a hyperlink that it will open on the same page? Or the same window? because it seems quite inconvenient if it opens in a new window.

PC2790
Community Champion
Community Champion

Please refer-https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-november-2018-feature-summary/

which also suggests there is no direct way to do it but copying & pasting the visuals is the only workaround

or

You can publish both the reports in one workspace and then pin the required visuals in the dashboard if that solves your purpose

amitchandak
Super User
Super User

@Anonymous , I doubt that is only way available as of now

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.