Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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.
Solved! Go to Solution.
Hi @Nietzsche
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
Hello @Nietzsche ,
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 💡
Proud to be a Super User! | |
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 :
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi @Nietzsche
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
User | Count |
---|---|
117 | |
75 | |
62 | |
50 | |
44 |
User | Count |
---|---|
174 | |
125 | |
60 | |
60 | |
57 |