Merge power bi pbix file

[sthomas2010]

Is there a way to combine 2 pbix files into new pbix or report?  

Reason-I have a pbix file that was created from my QuickBooks accounting database.  This file also had archive Excel files from past QB years which were combined to allow me to look at historical trends between 2 different QuickBooks accounting files.  But we recently migrated to a cloud-based QB and the connector I used will not run on the new cloud.  I have found a different connector to grab the data but it labels EVERYTHING differently so all my measures and mapping do not work.  The original powerbi file I created over the course of 2 years.  I am trying to figure out how to take the old PowerBi file (not refresh it-since the data is not changing) and create reports that would use the old file and I would create a new pbix file to grab from my accounting system with the new connector. 

[Ritaf1983]

Hi @sthomas2010 
please refer to this blog post: https://www.c-sharpcorner.com/article/tips-and-tricks-to-merge-two-power-bi-reports/

it can help and give you thinking direction

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

[sthomas2010]

@Ritaf1983 reading through the steps will this require that both pbix files have active connections to the data set?  The issue I have is that one pbix file is connected to a an old Quickbooks file with one type of ODBC connection and other pbix file is connected to our new Quickbooks dataset with a separate ODBC file.