How to copy the entire table vis from the Report View

[BenBlackswan]

Hello.

I have a table vis created on my Power BI desktop report view like this.

I would like to copy the entire table, right now Power BI gives me three options, Copy Value, which only copies one cell, Copy selection, which copies selected row and the headers and Copy Visual does not absolutely nothing.

How can I copy the whole table (all the values and the headers etc) into for example Excel? 

Thanks.

[Ritaf1983 · Accepted solution]

Hi @BenBlackswan 
if you need the data of visual in Excel you should "export " it.

Note: from desktop, it goes to CSV.
from service if it is published report to xlsx

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[Idrissshatila]

Hello @BenBlackswan ,

you could export it to excel as in the following

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote for my Community Mobile App Idea 💡

[BenBlackswan]

Hi Ritaf1983,

I am assuming there is no copy whole table solution then? Export is the only way to get the entire data off a vis?

[Ritaf1983 · Accepted solution]

Hi @BenBlackswan 
If you need the data from the visual to Excel - yes.
copy visual will work to copy and paste between other pages, pbi reports.
From data mode, you can copy the entire table :

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[Ritaf1983 · Accepted solution]

Hi @BenBlackswan 
if you need the data of visual in Excel you should "export " it.

Note: from desktop, it goes to CSV.
from service if it is published report to xlsx

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly