Showing results for 
Search instead for 
Did you mean: 

Different Data Sources within One Report with Multiple Tabs


Hi Community Gurus!



How do you combine PowerBI reports that are compiled within different pbix files?


Currently I have two pbix files that I'd like to consolidate into 1. The breakdown of the files are:


File 1: Has 4 tabs of reports within in. The data source is from my development environment.


File 2: Has 1 tab with one report within it. The data source is from my pre-production environment.


I am now trying to merge these files so that I have 5 tabs  by adding the report that is stored within File 2 to a 5 tab within file 1. How can I go about doing this?


I researched ways within this forum and noticed that this cannot be done per this post.  Does anyone know of a workaround.


This report is just a pilot report that needs to be approved by stakeholders. As a result, I'm just trying to get this information into one report with different tabs that the stakeholders can interact with to test the data and layout. 


After this is approved, I will then need to take these 5 reports and move them into my production environment. The data source will be completely different, but the reports will need to remain the same. Per this post I cannot achieve this. However, does anyone else know if this is possible?


Otherwise, I will need to rebuild these reports 2 different times.



Hi @PowerBINewbie_1,


1. I would suggest you vote up this idea or create a new one for the feature merging files.

2. It seems possible if you can make sure the final statement of all the queries are the same. For example, one query "Table1" is from an Excel file, you can enter these data by hand and there will be a new query "Table2". Now, you can delete "Table1" and change the name of "Table2" to "Table1". 



Best Regards,


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



Thanks. I had to just use two different reports. I couldn't combine them 😕


The first report was pulling from a data source. Lets call that A. Which had a whole set of data attached to the fields.

The second report was pulling from another data source. Also called A. But had different values attached because it is my test environment. Thus, when I tried to combine the fields I ran into errors because they are identical names with different values.


I did vote as you suggested.




Hi @PowerBINewbie_1,


What's the error message? Did you append these two queries?



Best Regards,


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

Helpful resources



We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!


The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors