cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AlB
Super User III
Super User III

Copying data from matrix visual

Hi all,

 

Imagine we have a matrix visual in our report, with a field in rows and several measures. I would like to copy that data and paste it somewhere else. I see there is an option to export the data to a csv file. By going to 'Show data', it is also possible to copy a single value or a row ('Copy selection'). I haven't been able though to copy directly the whole table (i.e. all the data in the matrix visual)

Is this possible at all? How?

 

Thanks very much.   

1 ACCEPTED SOLUTION

Hi @AlB,

 

I would suggest you vote up this idea.

 

 

Best Regards,

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
jdbuchanan71
Super User II
Super User II

Once you have published your report to the PowerBI service you will have more Excel as an export option and Summarized data is everything in the visual.  Is that what you are looking for?

 

export.jpg

Hi @jdbuchanan71

 

Thanks for your reply.  I'm actually talking about Power BI Desktop rather than the service.

mussaenda
Resident Rockstar
Resident Rockstar

Do you only need the data or also how you arranged it in matrix?

 

I had encountered a scenario with my collegues where the positions of exported data is different from the matrix. 

Since matrix is a visual, what we can only export is the data inside the matrix.

 

What we did is we saved the page, where the matrix is, in pdf then converted it to excel.

 

Take note that the matrix must show all data. You can adjust the page size.

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Hi @AlB,

 

I would suggest you vote up this idea.

 

 

Best Regards,

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.