Skip to main content
Microsoft Idea

Power BI

Completed

Allow Table and Matrix Data Exports to Match PowerBI Visual

Vote (6127) 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 13 May 2023 12:04:57

Feature has been released in public preview.

Comments (813)
WALTER's profile image Profile Picture

Power BI User on 05 Jul 2020 22:57:05

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

It would also be very useful to be able to "Ctrl C" Copy and "Ctrl V" Paste from BI to Excel. That is often quicker than exporting.

WALTER's profile image Profile Picture

Power BI User 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

David Wilson 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

Steve Ward 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

Ksenija Zegarac 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

Adi K. Asavaid 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

gary 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

B Sims 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

Joe Natarajan 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

Ryan Barkley 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.

Merged Idea (1)