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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.