Skip to main content

Power BI

Completed

Allow copy and paste between different PBIX's

Vote (3645) Share
Brett Gerhardi's profile image

Brett Gerhardi on 24 May 2016 16:44:02

Often we need to expand on an idea from one report further and copy and paste visuals/pages from one PBIX to another. This would be a huge productivity and quality benefit.

Administrator on 17 Nov 2018 01:54:09

We are excited to announce that this shipped in our November update of PBI Desktop: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-november-2018-feature-summary/#copyPaste For those asking, it will be included in the next version of Power BI Desktop for Report Server as well.

Comments (287)
Brett Gerhardi's profile image Profile Picture

4349cfbd 12fc-e911-a811-000d3a4f1cdd on 05 Jul 2020 22:45:23

RE: Allow copy and paste between different PBIX's

As others have said, Microsoft is making this too complicated. We need the ability to copy the report design, and if the exact same field names exist map those as well. We understand this process can and will force rework on some visualizations. But it's better than manually redoing every visualization.

Consider a scenario where you have multiple pbix files with identical (or very similar) data models. The data model then changes. Power BI provides no mechanism to make updates to the data models across files, or copy the visualizations to a pbix file with an updated data model.

Brett Gerhardi's profile image Profile Picture

e2e4650c d282-4de8-8e7f-1def94e37038 on 05 Jul 2020 22:45:03

RE: Allow copy and paste between different PBIX's

I have 2 pbix one for US and one for Other countries. I keep adding reports in US and just need to do some filter changes between both the files. Both files have same data structure. It would be nice if we could do the report and in one and just export it to be able to use in the other file. It takes hours to just re-do the same thing in the other file :(

Is there any update to this?

Brett Gerhardi's profile image Profile Picture

55a078e9 8d62-4f4f-ba06-97ad6380b0a1 on 05 Jul 2020 22:42:15

RE: Allow copy and paste between different PBIX's

I would sometimes be just happy for ability to copy formats to start with ... Just a suggestion :)

Brett Gerhardi's profile image Profile Picture

649757be 6ef3-4cc8-9e80-23b61615032e on 05 Jul 2020 22:42:00

RE: Allow copy and paste between different PBIX's

How about this: make it somewhat analogous to the Copy/Paste and Copy/PasteFormats function in Excel

For example, allow for a full copy/paste when the data models match.
If the data models don't match, allow a PasteFormats functionality to that we can quickly get all of the formatting and other settings correct...and then we can connect the data accordingly.

Brett Gerhardi's profile image Profile Picture

66048c92 62cd-4e6c-befe-c0f380159518 on 05 Jul 2020 22:41:26

RE: Allow copy and paste between different PBIX's

Need the ability for more than 1 developer to be able to write reports against the same PBIX or be able to copy reports into one PBIX for publishing

Brett Gerhardi's profile image Profile Picture

e769d60f ec92-42dd-a915-d383d69b70b6 on 05 Jul 2020 22:40:11

RE: Allow copy and paste between different PBIX's

need ability to move a pbix file and add it to a new tab on another pbix file

Brett Gerhardi's profile image Profile Picture

ecf89e2b 8d30-4c70-a51c-b327884e5d47 on 05 Jul 2020 22:39:55

RE: Allow copy and paste between different PBIX's

Need this feature too, the data dependencies is the user problem, an error message would be enough !

Brett Gerhardi's profile image Profile Picture

08fc0117 944f-4ffb-9098-18d929dc8fce on 05 Jul 2020 22:39:50

RE: Allow copy and paste between different PBIX's

This would be at the top of my wish list

Brett Gerhardi's profile image Profile Picture

dd43dd4d c6ca-47f5-a1ff-3a3977bf437f on 05 Jul 2020 22:39:08

RE: Allow copy and paste between different PBIX's

please.... make that happen in any way !!! As said before... let the user deal with any issues made by incompatible data models !!!!

Brett Gerhardi's profile image Profile Picture

3011e3a7 630a-4ab3-80c0-daa184676095 on 05 Jul 2020 22:39:06

RE: Allow copy and paste between different PBIX's

We dont want all the bells and whistles at this point in time. We can have a limited functionality where the developer knows that the data source in two pbix is identical. Otherwise for large reports with 30-40 sheets it is impossible to distribute the work to different people and get faster results for the end customer.
Sanjay Shah, Prosys InfoTech, Pune, India