Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Nietzsche
Helper IV
Helper IV

How to copy the entire table vis from the Report View

Hello.

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

 

Nietzsche_0-1697450892676.png

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.

1 ACCEPTED SOLUTION
Ritaf1983
Super User
Super User

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

Ritaf1983_0-1697451555404.png

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

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

4 REPLIES 4
Idrissshatila
Super User
Super User

Hello @Nietzsche ,

 

you could export it to excel as in the following

 

Idrissshatila_0-1697452657606.png

 

 

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 💡



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Nietzsche
Helper IV
Helper IV

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?

Hi @Nietzsche 
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 :

Ritaf1983_0-1697452559641.png

 

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

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile
Ritaf1983
Super User
Super User

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

Ritaf1983_0-1697451555404.png

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

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.