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.
Hi all,
I have two PBIX Files, One pbix Report file Contains 2 pages and another pbix Report file contains 2 pages. They use the same data as input.
Is it possible already to combine these two pbix files into one pbix File? Or do i just have to copy the visuals from one to another.
Kind regards,
Matthijs
Solved! Go to Solution.
HI @matthijs-eigen,
Yes, current you can't direct merge two pbix files to one.
For the copy/paste feature you mention, it required your files need have similar data models or this feature did not work.
Power BI Desktop November 2018 Feature Summary/#copyPaste
If you want to copy them smoothly, you can open the pbix file with compress software and find out the underline M query. (xxxxx.pbix\DataMashup\Formulas\)
Then you can merge the queries to one and process on the target pbix file to generate the corresponding query tables.
After these steps, you can simply copy/paste visuals between the pbix files.
Regards,
Xiaoxin Sheng
HI @matthijs-eigen,
Yes, current you can't direct merge two pbix files to one.
For the copy/paste feature you mention, it required your files need have similar data models or this feature did not work.
Power BI Desktop November 2018 Feature Summary/#copyPaste
If you want to copy them smoothly, you can open the pbix file with compress software and find out the underline M query. (xxxxx.pbix\DataMashup\Formulas\)
Then you can merge the queries to one and process on the target pbix file to generate the corresponding query tables.
After these steps, you can simply copy/paste visuals between the pbix files.
Regards,
Xiaoxin Sheng
You cannot combine two PBIX files but you have to create separate pbix file from scratch (power query, datamodel etc) .
However you can make a single Dashboard in Service using multiple reports in single workspace.
Regards
Vijay Perepa
Proud to be a Super User!
Do you have any guide or steps anywhere published to do this? I am interested on exploring that option
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 |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |