Skip to main content

Power BI

Needs Votes

Allow Table and Matrix Data Exports to Match PowerBI Visual

Vote (4721) Share
WALTER's profile image

WALTER on 12 Jul 2016 18:08:52

I have volumes of information to share with my teams that is best presented in tables and matrices. It would be a huge improvement if they were able to export the data from the visualizations and have the formatting in Excel match the formatting created within PowerBI.

This would be especially helpful for ongoing forecasting activities.

Administrator on 27 Jul 2020 18:00:47

Thanks for your feedback on this issue - while we'd like to enable this, there is currently no timetable around doing so. There is the option as a workaround the create a paginated view as a drillthrough of the visual and have a formatted version you can export to Excel, but understand this isn't a solution everyone can take advantage of currently.

Comments (692)
WALTER's profile image Profile Picture

e89492aa 72d9-45b2-874e-6748302dfee1 on 05 Jul 2020 22:56:43

RE: Allow Table and Matrix Data Exports to Match PowerBI Visual

This would be a very useful feature

WALTER's profile image Profile Picture

8a79aab1 7672-4933-9040-abaac839e8ed on 05 Jul 2020 22:56:41

RE: Allow Table and Matrix Data Exports to Match PowerBI Visual

I support the request for this option. I need the visualization as shown to be exported (or select All, Copy/Paste). One or multiple screen grabs of the presented visualization does not deliver to requirements.

WALTER's profile image Profile Picture

9a65852a fa05-4658-9372-c089e2d074ba on 05 Jul 2020 22:56:40

RE: Allow Table and Matrix Data Exports to Match PowerBI Visual

Please consider adding this. Possibly easier to implement than many other ideas on there and would be a massive improvement to the product.

WALTER's profile image Profile Picture

e80619ef b407-412c-8e54-5e7688b0e880 on 05 Jul 2020 22:56:40

RE: Allow Table and Matrix Data Exports to Match PowerBI Visual

Please, please add this option. Without that Power BI is almost useless for Self-service BI and/or report sharing.

We need a comment from Power BI developers on this!

WALTER's profile image Profile Picture

3860b697 0ba9-4d88-80b3-c2ddd3955094 on 05 Jul 2020 22:56:18

RE: Allow Table and Matrix Data Exports to Match PowerBI Visual

This data export feature is absolutely essential. Losing to Qlik, Tableau, etc.

WALTER's profile image Profile Picture

3fcc2c4d f2fc-4a6f-b5b5-91b6934e1202 on 05 Jul 2020 22:56:17

RE: Allow Table and Matrix Data Exports to Match PowerBI Visual

Essential for business

WALTER's profile image Profile Picture

a94f1d24 f10b-46d9-b950-fd16b18e1d21 on 05 Jul 2020 22:55:59

RE: Allow Table and Matrix Data Exports to Match PowerBI Visual

Functionality if needed. Having associates export and rebuild in a pivot is not efficient.

WALTER's profile image Profile Picture

431581a6 37a5-4ca4-bafe-46baf59d7e7a on 05 Jul 2020 22:55:40

RE: Allow Table and Matrix Data Exports to Match PowerBI Visual

Users should not have to redo the pivots. Please add the functionality

WALTER's profile image Profile Picture

c8aa91ca cb3f-4cae-9799-1837de0c8c40 on 05 Jul 2020 22:55:33

RE: Allow Table and Matrix Data Exports to Match PowerBI Visual

I agree, this was one of the first feature requests received from our end users upon release. Please add the functionality.

WALTER's profile image Profile Picture

dad4505f e036-4d5c-9282-a9f7b25d3953 on 05 Jul 2020 22:55:30

RE: Allow Table and Matrix Data Exports to Match PowerBI Visual

This is a big problem for my organization. We use the matrix visualization extensively. As it currently stands, people can't export due to the massive amounts of data underlying a matrix that has many drill down layers. The export should only contain what the matrix actually shows.