Power BI

Completed

Copy/Paste from Power BI Desktop

Vote (1783)

on 20 Apr 2018 02:40:58

Please allow Copy/Paste functionality from Power BI Desktop. We often need to recreate PBI reports in Excel just so we can Copy tables or charts and paste into PowerPoint or simply email it. Need stronger integration with other Office products. Copy/paste seems so basic.

Note: Our company uses PBI Desktop and PBI Report Server (on SQL server) - cloud services are not an option because of Protected Health Information.

Administrator on 17 Nov 2018 01:46:04

We shipped copy and pasting visuals between .pbix files in November. You can learn more about this feature here: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-november-2018-feature-summary/#copyPaste This is in addition to the copy data features we added in September: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-september-2018-feature-summary/#copy Note that you can get reports into PowerPoint using the export to PowerPoint feature, and if you want specific improvements make sure to vote on those ideas. If you want to copy an image to your clipboard instead of the actual visual so you can reuse it anywhere, make sure to vote on this idea: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/11698812-copy-screenshot-of-visual-to-clipboard And you can vote on this idea for more copy data scenarios (such as whole table of data to clipboard) https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/6696392

Comments (91)

Comments (91)

Power BI User on 05 Jul 2020 23:29:47

RE: Copy/Paste from Power BI Desktop

Necessary to take into account the country configuration in order to add a dot or a comma for decimal numbers, because now it always adds a dot and may not be useful once pasted in an Excel file.

Power BI User on 05 Jul 2020 23:29:44

RE: Copy/Paste from Power BI Desktop

Hello, we've been trying this functionality and what we found that could be improved is the format of the empty cells when pasted. Now if its an empty cell with number format it is pasted as "(In blank)", it would be better to paste a "0".

higashi on 05 Jul 2020 23:29:32

RE: Copy/Paste from Power BI Desktop

It is necessary to have a function that can copy all values while preserving the row and column formats expressed in matrix.

Power BI User on 05 Jul 2020 23:29:20

RE: Copy/Paste from Power BI Desktop

Hello, is there an estimated Date where this upgrade will be included? Exporting to Excel for example is too much important for companies that uses PBI.

Rebecca on 05 Jul 2020 23:29:04

RE: Copy/Paste from Power BI Desktop

I have been trialling this in the service and while I am glad that you are working on it, it is no where near complete as you cannot copy and paste the entire report and when you do it to a matrix it unpivots the data. Most end users don't want to or know how to re-pivot work every time that they want it exported.

Didier Garro on 05 Jul 2020 23:28:27

RE: Copy/Paste from Power BI Desktop

Could be great if we can link PBI with SAP BW as well, looking forward create SAP reports and refresh the dashboards of PBI.

Rebecca on 05 Jul 2020 23:27:42

RE: Copy/Paste from Power BI Desktop

Looking forward to this feature being released. I'm hoping you apply it to Power BI service also as it would be really helpful to be able to copy data out of a Power BI report into Excel for presentations/meetings ect.