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
ldwf
Helper III
Helper III

Merging .pbix files

Is it possible to merge two .pbix files into one so that one dashboard can be built?  If both .pbix files use the same data source and one developer works on a page and another works on a second page, can the two .pbix files successfully be merged so that there is one .pbix file with two pages?  I'm thinking if the two files are in Github repository, can Github merge the two files into one?

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

Hi @ldwf ,

Yes, it is possible to merge two .pbix files into one if both files use the same data source. However, it is important to note that merging two .pbix files can be a complex process and requires careful planning to ensure that all the data and visuals are properly integrated.


One way to merge two .pbix files is to use the "Import" feature in Power BI Desktop. Here are the steps to follow:

 

Open the first .pbix file in Power BI Desktop.

Click on "Home" tab and select "Import" from the "External Data" section.

Select the second .pbix file and click "Open".

In the "Navigator" window, select the data tables and visuals that you want to import into the first .pbix file.

Click "Load" to import the selected data and visuals into the first .pbix file.


After importing the data and visuals from the second .pbix file, you can rearrange and customize the visuals as needed to create your dashboard.


It is important to note that merging two .pbix files can be a complex process and requires careful planning to ensure that all the data and visuals are properly integrated. You may also need to adjust the data model and relationships to ensure that the data is properly integrated.


Regarding Github, it is possible to merge two .pbix files using Github, but it is not recommended as it can be difficult to resolve conflicts and ensure that all the data and visuals are properly integrated. It is generally recommended to use the "Import" feature in Power BI Desktop to merge two .pbix files.

 

 

If it does not help, please provide more details .

 

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
Hbolli1991
New Member

Hi @v-rongtiep-msft 


Can you please provide us with short instructional videos on the PBIX merging process, including screenshots and the corresponding steps outlined in the community?

v-rongtiep-msft
Community Support
Community Support

Hi @ldwf ,

Yes, it is possible to merge two .pbix files into one if both files use the same data source. However, it is important to note that merging two .pbix files can be a complex process and requires careful planning to ensure that all the data and visuals are properly integrated.


One way to merge two .pbix files is to use the "Import" feature in Power BI Desktop. Here are the steps to follow:

 

Open the first .pbix file in Power BI Desktop.

Click on "Home" tab and select "Import" from the "External Data" section.

Select the second .pbix file and click "Open".

In the "Navigator" window, select the data tables and visuals that you want to import into the first .pbix file.

Click "Load" to import the selected data and visuals into the first .pbix file.


After importing the data and visuals from the second .pbix file, you can rearrange and customize the visuals as needed to create your dashboard.


It is important to note that merging two .pbix files can be a complex process and requires careful planning to ensure that all the data and visuals are properly integrated. You may also need to adjust the data model and relationships to ensure that the data is properly integrated.


Regarding Github, it is possible to merge two .pbix files using Github, but it is not recommended as it can be difficult to resolve conflicts and ensure that all the data and visuals are properly integrated. It is generally recommended to use the "Import" feature in Power BI Desktop to merge two .pbix files.

 

 

If it does not help, please provide more details .

 

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-rongtiep-msft 

Can you please provide us with short instructional videos on the PBIX merging process, including screenshots and the corresponding steps outlined in the community?

Hi @ldwf,

 

On my version of PowerBI Desktop there is no such choice: "Click on "Home" tab and select "Import" from the "External Data" section." 

External Data section allows for a variety of sources but there is no "Import" option, nor is there a way of opening/importing  an existing *.pbix file. 

Would greatly appreciate it, if you could provide screenshot(s) or any other pertinent info.

power bi version installed is Version: 2.121.942.0 64-bit (September 2023)

Thanks for the information

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.