Search

How to export PowerView data into Excel by Isabel Marcelino

Active

15
0
Sign in
 to vote
Type: Suggestion
ID: 777262
Opened: 1/23/2013 7:45:56 AM
Access Restriction: Public
0
Workaround(s)
Apparently, there is no easy way to export data from PowerView to Excel. Even in Excel 2013, the behavior that I would need was to have slicers shared between PowerPivot and PowerView; applying one slicer, the same would be reflected between PowerPivot and PowerView.
PowerView users will be able to view, analyse and filter the report. If they need more detailed information or data lists, they will be able to export that data to Excel. For instance, if we are making an analyse about products sold by year and countries in PowerView, I would like to be able to export that info to Excel and manipulate (add calculations, etc.) or print the data.
Details (expand)

Product Language

English

Category

Reporting Services

Proposed Solution

To have an export to excel option in powerview as there is an export to powerpoint option.

Primary Benefit

Improved User Interface

Other Benefits

 

Virtualization

 
File Attachments
0 attachments
Sign in to post a comment.
Posted by Alastair Coats on 4/4/2013 at 5:19 PM
Yes this is crucial. Using the powerful powerview filters to select particular records is great, but i want to then copy that out to excel for use in mailmerges etc.
Posted by mmala on 2/11/2013 at 1:50 PM
I second this request. I would guess that Microsoft's intent is that we use PowerPivot instead, and keep everything in excel to begin with but, when your users aren't familiar with how to use pivot tables, and Power View has such a nice, easy to use interface, it's unfortunate that we don't have that option. Hopefully MS will rethink their decision and include that functionality in a future release
Sign in to post a workaround.
© 2013 Microsoft Corporation. All rights reserved. Microsoft Connect Terms of Use | Trademarks | Privacy Statement