Is there a way to merge several desktop Power BI files, or just need to start over from scratch?

[mmace1]

I've made 4 seperate Power BI files.  Right now they upload to 4 seperate reports, from which a single dashboard is made. 

At this point, it's apparent it'd probably make more sense to have a single Power BI file that covers everything in the 4 seperate ones.  

Is there a way to import files together at all?  e.g. - create a new Power BI file, then import all the setups from the 4 old ones, then go ahead and start cleaning it up. 

Or, would I just need to rebuild everything from scratch? 

[GilbertQ · Accepted solution]

Hi @mmace1

What I would do in your situation is create a new Power BI Desktop file.

And then also have your current 4 Power BI desktop files open.

• Go into the Query Editor from your first Power BI Desktop file, click on your table and then right click and selected Advanced Editor.
  • Copy everything from within the Advanced Editor.
• I would then go to my New Power BI Desktop File, go into the Query Editor, click on Get Data, and select Blank Query.
  • Then once again right click and select Advanced Editor.
  • Then paste this into the Advanced Editor.
  • Then rename this table with the same name as you had in your original Power BI Desktop file.

I would then repeat this for the other 3 files.

And then finally re-create all the report sheets. I know that this is a bit of a time consuming effort, but I cannot think of any other way to get it all into one file.

A

[mmace1]

"Go into the Query Editor from your first Power BI Desktop file, click on your table and then right click and selected Advanced Editor.

• Copy everything from within the Advanced Editor."

I didn't know that was there, and that saves quite a lot of time at least - thanks. 

[GilbertQ]

Hi @mmace1

Awesome glad it has helped.