Unir dos .pbix

[Anonymous]

Hola.

He realizado dos analisis en archivos .pbix diferentes.

Y ahora me gustaria unificar esos dos archivos en uno solo. ¿Es posible hacer eso sin tener que volver a realizarlos de nuevo?

Un saludo.

[BA_Pete · Accepted solution]

Hi @Anonymous ,

There's not a way to merge them per se, but you can move the main assets from one file to another fairly quickly:

In power query, you can multi-select queries (hold down CTRL or SHIFT while selecting) and copy them from one file and paste into the query section of another file. You will need to re-establish relationships.

Measures are a bit trickier. For the most part, you will need to copy and paste them from one file to another. You can make this much quicker by creating a blank query in the file you want to move measures FROM and pasting this code over the default code:

= OleDb.Query("Provider=MSOLAP.8;Data Source=localhost:53931;Update Isolation Level=2",
"select 
   MEASUREGROUP_NAME, 
   MEASURE_NAME, 
   EXPRESSION
from $SYSTEM.MDSCHEMA_MEASURES
where MEASURE_AGGREGATOR = 0")

You will need to use a tool like DAX Studio to get your localhost number (replace the number 53931 in the first line above), but this will give you a full table and measure listing that you can export to Excel making the copy/paste process significantly faster than trying to do it between two PBIX files directly.

Pete

[v-shex-msft · Accepted solution]

HI @Anonymous,

Current power bi does not support combine pbix files.
For this requirement, you can copy one report query tables to another file, then you can use the copy/paste contents feature to manually move these content between two pbix files.

Power BI Desktop November 2018 Feature Summary | Microsoft Power BI Blog | Microsoft Power BI

Regards,
Xiaoxin Sheng

[BA_Pete · Accepted solution]

Hi @Anonymous ,

There's not a way to merge them per se, but you can move the main assets from one file to another fairly quickly:

In power query, you can multi-select queries (hold down CTRL or SHIFT while selecting) and copy them from one file and paste into the query section of another file. You will need to re-establish relationships.

Measures are a bit trickier. For the most part, you will need to copy and paste them from one file to another. You can make this much quicker by creating a blank query in the file you want to move measures FROM and pasting this code over the default code:

= OleDb.Query("Provider=MSOLAP.8;Data Source=localhost:53931;Update Isolation Level=2",
"select 
   MEASUREGROUP_NAME, 
   MEASURE_NAME, 
   EXPRESSION
from $SYSTEM.MDSCHEMA_MEASURES
where MEASURE_AGGREGATOR = 0")

You will need to use a tool like DAX Studio to get your localhost number (replace the number 53931 in the first line above), but this will give you a full table and measure listing that you can export to Excel making the copy/paste process significantly faster than trying to do it between two PBIX files directly.

Pete