How can we improve Power BI?

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.

1,800 votes
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

Laura Collie shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
completed  ·  AdminAmanda Cofsky (Program Manager, Microsoft Power BI) responded  · 

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

89 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • noname commented  ·   ·  Flag as inappropriate

    If your table has columns with the Total numbers in them, then : Right mouse click on the " Numbers (that are in a total line)" then "Copy Selection". Then, paste into Excel.

    Do not click on the "WORD" that says Total, for some reasons it does not work for me.

  • Gopherhockey commented  ·   ·  Flag as inappropriate

    This is marked completed but the answer is wrong. I have a whole table of data in Power BI that I need in Excel. If I export it, its not in table format - its in one row sorted in a way I cannot use. I just want to select an entire column or row of numbers and paste them into Excel (or other documents). Why is this so hard.

  • Anonymous commented  ·   ·  Flag as inappropriate

    This is not even half-completed, e.g. One cannot copy/paste single cell value from a table. Some people in my company complains that they are paying money for beta-testing Power BI and I really can't argue with them if such basic functionality is missing.

  • Bobby Kendall commented  ·   ·  Flag as inappropriate

    Are there future plans to enhance copy/paste further? The "completed" solution is half baked in that it unpivots the matrix, on table visuals you have to export the data as there is no copy selection option that grabs the whole table, and it is difficult to tell what you have selected. Just not a very elegant solution at the moment

    Our project team thought we made it to the promise land only find out integration with office/excel is poor or clunky at best. End users and report authors are frustrated by this even with the new update. Perhaps I am missing something but the copy/paste seemed to be released in previous update? Not sure why it is being included in the January update?

  • Anonymous commented  ·   ·  Flag as inappropriate

    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

  • Alexandre commented  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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.

  • Dennis commented  ·   ·  Flag as inappropriate

    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 ...

  • Matt commented  ·   ·  Flag as inappropriate

    please allow to copy visuals/charts from Power Bi desktop to Power Point and Tables to Excel.

    Many thanks!

  • Momo Hsieh commented  ·   ·  Flag as inappropriate

    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!

  • Jeff commented  ·   ·  Flag as inappropriate

    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.

  • wayne commented  ·   ·  Flag as inappropriate

    would want to be able to copy/paste visuals/elements from one pbix report page to another pbix

  • NICOLE FALK SMITH commented  ·   ·  Flag as inappropriate

    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.

  • Anonymous commented  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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

  • David commented  ·   ·  Flag as inappropriate

    Will this feature also cover copying and pasting into another .pbix file connected to the same model?

← Previous 1 3 4 5

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.