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

e017890a 0f05-45e3-b5a1-b2645bde5e99 on 05 Jul 2020 22:39:00

RE: Allow copy and paste between different PBIX's

Is a potential compromise to reduce complexity by expressly stating and assuming (to cut / paste visuals etc) that all data tables / relationships / measures between the two pbix files in question are IDENTICAL ?

Brett Gerhardi's profile image Profile Picture

ea8e7c46 e5a1-401e-95c1-92494bea4cc8 on 05 Jul 2020 22:38:48

RE: Allow copy and paste between different PBIX's

This would be at the top of my wish list as I am now involved with large reports and the process of moving them through a developement process. Having a simple copy/paste meachanism - and just letting the user deal with any issues because of incompatible data models would be great.

Brett Gerhardi's profile image Profile Picture

86a234d5 1aca-e711-8119-c4346bb5988c on 05 Jul 2020 22:38:46

RE: Allow copy and paste between different PBIX's

I agree with Scott. Being able to copy and paste tabs between .pbix files with the same data model would be extremely helpful. Having this ability really is critical for change management between different versions of .pbix files as updates are made. I would be able to live with this ability being limited to .pbix files that share a common data model.

Brett Gerhardi's profile image Profile Picture

4349cfbd 12fc-e911-a811-000d3a4f1cdd on 05 Jul 2020 22:38:46

RE: Allow copy and paste between different PBIX's

As others are saying, there's a fundamental problem when the data model and report definition are both required to be maintained in a single PBIX file. There have to be better ways to manage reports and data models that change over time.

Brett Gerhardi's profile image Profile Picture

e18056d8 a20a-4d16-b49c-aec37d9aeb68 on 05 Jul 2020 22:38:46

RE: Allow copy and paste between different PBIX's

I second that it should not be complicated if we are using different reports connected to the same SSAS server. there is no data dependency issues in this case.

Brett Gerhardi's profile image Profile Picture

4224beb3 af74-ea11-a811-000d3a579c38 on 05 Jul 2020 22:38:46

RE: Allow copy and paste between different PBIX's

This feature is CRITICAL to alleviating the change management burden. Please let us be the ones to break/correct the data model if we’re careless enough to copy PBIX tabs between files with different data models. Just a red X that says "data models don't match, please correct" would be fine.

Brett Gerhardi's profile image Profile Picture

b90cfc26 8418-454d-aaac-474e56bb984d on 05 Jul 2020 22:38:44

RE: Allow copy and paste between different PBIX's

It will be very useful

Brett Gerhardi's profile image Profile Picture

db5b53be 9328-41e5-b6f5-b9e7f05f3b56 on 05 Jul 2020 22:38:38

RE: Allow copy and paste between different PBIX's

This is an essential feature. Just found myself with a number of developmental files that I now need to merge - but I find that I have to re-create part of this work in the other files! One file has a number of complicated calculated columns that I'd like to re-use without having to start with a copy of the file.

Brett Gerhardi's profile image Profile Picture

d3e17cdd 42bf-45a7-b365-f0e091c2d356 on 05 Jul 2020 22:38:27

RE: Allow copy and paste between different PBIX's

Would welcome the copy and paste PAGE function, but could live with the copy and paste VISUAL function between two unique pbix files. Would enable individual PowerBI users to create and share, whilst also being in their 'own' pbix file at the same time. Managing three different departments with their own dashboards is my driver for this.

Brett Gerhardi's profile image Profile Picture

4ebe8852 e0c5-4fd0-8f4e-4c8fbd55cdfd on 05 Jul 2020 22:38:24

RE: Allow copy and paste between different PBIX's

If copy/paste isn't feasible, then the ability to import a page from another PBIX would be a good workaround.