Is it possible to merge two PBIX files into one?

[matthijs-eigen]

Hi all,

I have two PBIX Files, One pbix Report file Contains 2 pages and another pbix Report file contains 2 pages. They use the same data as input. 

Is it possible already to combine these two pbix files into one pbix File? Or do i just have to copy the visuals from one to another.

Kind regards,

Matthijs

[Anonymous · Accepted solution]

HI @matthijs-eigen,

Yes, current you can't direct merge two pbix files to one.

For the copy/paste feature you mention, it required your files need have similar data models or this feature did not work.

Power BI Desktop November 2018 Feature Summary/#copyPaste 

If you want to copy them smoothly, you can open the pbix file with compress software and find out the underline M query. (xxxxx.pbix\DataMashup\Formulas\)
Then you can merge the queries to one and process on the target pbix file to generate the corresponding query tables.
After these steps, you can simply copy/paste visuals between the pbix files.

Regards,

Xiaoxin Sheng

[VijayP]

@matthijs-eigen 

You cannot combine two PBIX files but you have to create separate pbix file from scratch (power query, datamodel etc) .

However you can make a single Dashboard in Service using multiple reports in single workspace.

Regards

Vijay Perepa

[Chava1881]

Do you have any guide or steps anywhere published to do this? I am interested on exploring that option