Skip to main content

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

Marc Ybarsabal on 06 Jul 2020 00:09:02

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

What is the holdup? This is an incredibly common use case. I'm tired of having to explain that Microsoft doesn't think that exporting data is important. #TableauCanDoIt

WALTER's profile image Profile Picture

Farhad P. on 06 Jul 2020 00:08:55

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

This idea was floated and requested way back in 2016. It's been approx. 4 years with no hope as to when it will be implemented. How can we escalate this issue?

WALTER's profile image Profile Picture

Kiran Hosakote on 06 Jul 2020 00:08:45

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

BI Helper Matrix

BI Helper Matrix is a powerful and easy to use Chrome extension for Matrix and Table data exports from Power BI. You can download your Power BI matrix and table visuals as MS Excel files, with support for full vertical and horizontal scrolling of the visuals.

The Excel file retains your matrix data pivots, so you continue to see your information at the SAME level of detail as in your Power BI report. Download and test BI Helper Matrix at https://bihelper.tech/bihelper_matrix.html.

WALTER's profile image Profile Picture

jb13606 on 06 Jul 2020 00:08:38

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

Hi,
Please assist in add this function to Power BI Desktop.
It's necessary for end users.
If we need to organize data again , then why do we need Power BI?
Maybe just using excel is fine...
Looking forward to receiving a good news.
Many thanks.

WALTER's profile image Profile Picture

Armin K. on 06 Jul 2020 00:08:31

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

Please add this feature soon!

WALTER's profile image Profile Picture

Jason Campbell on 06 Jul 2020 00:08:26

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

Since PBI is a tool for data consumption, can this function be escalated? I mean, I'm pretty sure no one wants to build an additional paginated report. I absolutely do not.

Most all other BI tools allow this (for good reason). Please, help make our (Developers) life easier.

WALTER's profile image Profile Picture

Emma on 06 Jul 2020 00:08:22

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

please, please, please, please, please include this function!

WALTER's profile image Profile Picture

Power BI Ideas Admin on 06 Jul 2020 00:08:21

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

Definitely need this to be functional for the end user!

WALTER's profile image Profile Picture

Power BI User on 06 Jul 2020 00:08:14

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

Agree! Please fix, very annoying to have to reformat data back to table format for end users.

WALTER's profile image Profile Picture

Derek Tjeerdema on 06 Jul 2020 00:08:10

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

Probably the most needed feature in Power BI IMO. This would make it so much easier for the end user if they want to play with the data or do analysis. Please fix this!

Merged Idea (1)