Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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
Proud to be a Datanaut!
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
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
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
Proud to be a Datanaut!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |