cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ldwf
Helper II
Helper II

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

3 REPLIES 3
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 @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
Join Arun Ulag at MPPC23

Join Arun Ulag at MPPC23

Get a sneak peek into this year's Power Platform Conference Keynote.

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors