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

Andrew te Groen on 06 Jul 2020 00:09:11

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

Another feature PowerBi desperately needs!

WALTER's profile image Profile Picture

Kiran Hosakote on 06 Jul 2020 00:09:10

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

This is solved - we've built and launched a Chrome extension called BI Helper Matrix for table and matrix data exports from Power BI. See my post dated Feb 24, 2020.

Go to https://bihelper.tech/bihelper_matrix.html to download and test the solution.

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!

Merged Idea (1)