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.
I have a series of .pbix files recently created through Power BI.
In some cases I would like to combine them into a single file, with multiple tabs. Is there a way to "copy" the tab of one report and add it to a different .pbix file - similar to Excel? I would like to avoid rebuilding it if I can, and looking to create a single file, with multiple tabs.
Also, if I move the .pbix file to an alternative location (off of my desktop), is it as simple as a cut/paste to a network location?
Thanks for your input.
Solved! Go to Solution.
I mean most formulas, such as calucated columns or measures, or any SQL type statements you might have for your datasources.
Hi @irnm8dn,
I'm not aware of a tool that would quickly merge the contents of two (or more) pbix files. So you would need to rebuild. At least you can copy/paste most across from one PBIX File to the other so hopefully it doesn't take too long.
And yes, if you want to move the PBIX file to the network location, cut and paste is perfectly fine.
Cheers,
Phil
Thanks Phil. Can you explain what yopu mean that I can "copy/paste most across from one PBIX File to the other", not sure what you mean.
As always, your help is much appreciated.
Thanks.
In Excel if you select a Sheet that has PowerPivot Pivot Table (built using severeal tables from the Data Model)
Right-click on the Sheet/Tab - select Move/Copy to a brand new book (Excel file)
ALL tables used to build that PowerPivot Pivot Table are imported in the brand new Excel File
(Relationships set up, Measures included)
Please note NOT all tables from the Data Model but ALL used in the creation of the PowerPivot tables on that specfic Sheet/tab
This would be a nice feature to have in PBI
(along with many others that have existed in Excel for years...)
Yes, this feauture to be implemented would be awesome. In a dashboard you can create a lot of visuals that can take up to 2-3 hours. If we could copy the tab into another pbix by simply copy/pasting would be perfect.
I mean most formulas, such as calucated columns or measures, or any SQL type statements you might have for your datasources.
Although Power BI Desktop does keep track of Recent Data Sources so that might also be useful in speeding up your rebuild.
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 |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |