How to combine 2 PBIX file into 1 ?

[admin11]

Hi All

I have 2 company GL table.

Cmpany A GL Code for Revenue = 5000100

Cmpany B GL Code for Revenue = 200000

So i have manually recode the GL Code for each company and i am able to get the correct P&L report.

Now i like to ask how to combine these 2 PBIX fle into 1 ?

Both company have same data structure below :-

Company A PBI file :-

https://www.dropbox.com/s/p4awj51j7umkn1a/PBS%20GL.pbix?dl=0

Company B PBI file :-

https://www.dropbox.com/s/k6q3szxcrc44w5r/PBT%20GL.pbix?dl=0

Hope some one can advise me.

Paul

[PaulDBrown · Accepted solution]

@admin11 

Here is one way (I suggest you save a copy of PBIX2 as a backup in case something goes wrong in the process...):

1) open up both files. Go into Power Query in PBIX1 and copy the code from each of your fact tables from the advanced editor and paste it into new blank queries in PBIX2.

2) If your fact tables include a column identifying each company, you can append the corresponding tables (new queries from PBIX1 to Tables in PBIX2). You can then use this column to filter visuals or pages. If they don't include this ID, create a new column for the company ID in each fact table before appending,

3) copy any visuals from PBIX1 into PBIX2 which are missing in PBIX2.

It should take no more than "5 minutes" to carry out the whole process

[admin11]

@PaulDBrown 

I have try the manual approach , quite similar to your recommendation. I encounter some issue.

Below is the post i like to know how to clear the error ?

https://community.powerbi.com/t5/Desktop/How-to-interpreted-expression-for-PnL-Table/td-p/1706490

hope some one can advise me.

Paul

[PC2790]

Hello @admin11 ,

Combining 2 pbix files is not possible in a direct way.

Couple of way outs:

1) You can publish both the files in one workspace & pin the required visuals in a daschobard.

2) Copy paste the required visuals from one file to another, the feature got release in November 2018 with details here

Please see a similar thread with the same requirement:

https://community.powerbi.com/t5/Desktop/Can-I-combine-2-pbix-file-into-1-report/m-p/1698202#M674198