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 (816)
WALTER's profile image Profile Picture

Jon Thompson on 05 Jul 2020 22:58:20

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

Not much help to export CSV and create pivot table. Might as well create in Excel one time.

WALTER's profile image Profile Picture

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

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

I just want a same display format in Excel as I can see in BI visual matrix so that I can give it to boss.

WALTER's profile image Profile Picture

Anon on 05 Jul 2020 22:57:12

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

Agreed! I'm spending a ton of time recreating a format in Excel that I can see in PowerBI. Quite frustrating haha

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

Merged Idea (1)