How to add/merge one PBIX file to another PBIX file

[Meraj]

We have master PBIX file having multiple reports which we refresh weekly and publish to Power BI service. we just wanted to know how to add/merge/combine other pbix reports to master pbix file as we are getting multiple pbix files to be added into the master pbix file.

[v-robertq-msft]

Hi, @Meraj 

As far as I’m concerned, you can only add data sources to your current pbix file and use “Merge query” and “Append query” in the Power Query to combine your dataset with the data in the other data sources, like this:

Click “New Source” to add a new data source:

Then use “Merge query” and “Append query” to combine data:

More info about “Merge query” and “Append query” in the Power query

Best Regards,

Community Support Team _Robert Qin

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

[Greg_Deckler]

@Meraj Not sure I fully understand what you are asking, but perhaps take a look at this article and it may help.

Power BI Usage Models in Pictures! - Microsoft Power BI Community