Combining separate PBI reports into a single PBIX file (same underlying datasets,relationships etc)

[Anonymous]

So for the purpose of demoing some reports I created seperate reports but all had the same underlying datasets, logical joins, etc.

Now I need to combine these into a single file. How can I effectivley 'stitch' these report pages together into a single PBIX file? Is there a way of importing the pages?

[v-yulgu-msft]

Hi @Anonymous,

Unfortunately, it is not supported to combine separate report pages into a single .pbix file.

Regards,

Yuliana Gu

[themistoklis · Accepted solution]

@Anonymous

The latest update which was realeased just yesterday allows the user to copy and paste objects between PBIX (Workspace) files.

I think this will solve your problems.

Download the latest powerBi desktop which includes the November update and hopefully you will do what you want

[themistoklis]

@Anonymous

Maybe this will help you.

These are workarounds. You cant easily copy and paste objects or pages from one workspace to another

[Anonymous]

I believe this method uses the online workspace? Can this be done locally on my machine. I have all the seperate PBIX files in one directory.

[themistoklis]

@Anonymous

I dont think you can do this. You need to create most of the objects (or pages), if not all, in a new workspace

[Anonymous]

So if I upload all the sepearte pages into a new workspace, can I then download the workspace content into a single Power bi file? Reason being I need to load the single report locally when presenting.