Forum Discussion
Merging 2 Power BIs
- 5 years ago
Anonymous you have to select all queries you want. Easiest way is to select the first thing in your query list - either a query or a Group if you have created those. Then Shift-Click the last thing in that list. You can then either press CTRL-C to copy, or right-click all of the selected items and select copy.
Then in the other file, right-click in the query listing area, and select Paste.
As lbendlin indicated, you cannot just drag/drop data. However, if the reports have different underlying data, you can do this:
- Open file one. Open Power Query via Transform on the home ribbon.
- Open file two. Open Power Query.
- In file two, copy ALL queries in the Power Query window. Select all of them and press CTRL-C.
- In file one, press CTRL-V.
- Close and Apply in File one.
- In file two, just close.
- In file two, copy all visuals by selecting them, CTRL-C, then paste into file one.
The only thing you will have to do now is:
- create relationships in the Model tab.
- Create measures and calculated columns if any. You copy the DAX code for this but not the measures/columns themselves.
If the data sources in file 1 and 2 are similar or the same, but with different transformations, it can be a bit trickier as you will duplicate the sources and possibly have naming conflicts on the queries.
WIth the December 2020 desktop update, you can also enable the preview feature for direct query of datasets. You could then create a third PBIX file that brought in the other two datasets and create visuals and relationships as desired. But that is in preview status, and would require 3 final reports vs consolating into 1. But if your first two reports are very complex with a lot of DAX, that might be faster.
Hi Anonymous ,
Tried your method but the control C and control V doesn't work on the power query... I also did not see any selection appeared when I press control-C. Please help!
- edhans5 years agoCommunity Champion
Anonymous you have to select all queries you want. Easiest way is to select the first thing in your query list - either a query or a Group if you have created those. Then Shift-Click the last thing in that list. You can then either press CTRL-C to copy, or right-click all of the selected items and select copy.
Then in the other file, right-click in the query listing area, and select Paste.