Copy/Paste from Power BI Desktop
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.
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
why not simply export the data ready for excel / powerpoint usage?
eg. a stacked bar chart should export as a table with columns as rows and categories as columns
This then allows us to use third party applications (we're not going to stop using power point plugins, sorry but third party graphs are simply better). Otherwise we need to do all our processing in the query editor, which is significantly less user-friendly
Nickolaj Jessen commented
@alexandre - I think you can already do that after you publish it?
What about "Copy all data" function? Selecting one by one is really time consuming and nearly impossible on large datasets. It would perfectly fit with "Copy data" and "Copy selection".
Gerry Tseng commented
Need to copy Power BI visuals into an Outlook email the same way you can do this today with Excel. In Excel a copied line chart in Outlook will show data values as you hover your mouse over a line marker. Right now all we can do is screenshot a chart from Power BI and there's no ability to hover over markers. Displaying all the data values through labels will become extremely messy.
David Cresp commented
What would be even better would be if you could paste link from Power BI Service to other applications in the same way that you can paste link from Excel to other applications. We use this functionality in Excel in every report.
Especially an easy way to export tables with data. No to the visuals people still would like to have a set of data behind them. Exporting into a csv file is not how it should be ...
please allow to copy visuals/charts from Power Bi desktop to Power Point and Tables to Excel.
Momo Hsieh commented
as team workers, multiple developers usaully need to simutaneouls create different tabs in the same report/dashboard. Need this feature very much! Please enable it. Thank you very much!
Ahsan Khawaja commented
Yeah would love to see better integration with Office Products. That arn't a 3rd party. Looking forward to this. Power BI team usually great.
would want to be able to copy/paste visuals/elements from one pbix report page to another pbix
NICOLE FALK SMITH commented
I like that we can now copy cell and row level data. Now, I would love to be able to copy column level data. For example, this is needed in order to select all the email addresses of the population I'm trying to reach.
Hi, we really like what you have added and are looking forward to more. But we have noticed that there are some oddities with how the Copy selection works.
What we see is a matrix often unpivots the table (rows become columns and visa versa) and not give the info as displayed. Also its hard to figure out how to select the entire table, and copy as is.
Alex Go commented
Tableau has the copy image and data functions which is a great help in creating reports in word or excel formats. I hope Power BI can follow and offer this functionality
Visa,Resident Permit http://Glorecdoc.com
Will this feature also cover copying and pasting into another .pbix file connected to the same model?
And also if it could be available on the "Show Data" matrix that appears
Loving the new feature to copy from table/matrix visuals. Would love it to be able to copy from other visuals, particularly Card Visuals which our users need to copy numbers/text from
Neil MacMullen commented
I'd be quite happy to be able to right-click on a table entries (or multiply-selected entries) and copy cell/row as text. I often work with external command lines tools and getting basic data out of powerbi to share with these seems fundamental
We really need the copy as-is from table, and matrix