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

Chuck Dokmo on 05 Jul 2020 22:41:47

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

YES. YES. YES. Not having this capability is a serious constraint. I need to export large matrices in my visualized format to PDF for sharing via email with external, non-Microsoft users.

WALTER's profile image Profile Picture

Stefanie Lopez-Howard on 05 Jul 2020 22:41:30

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

I need for my executive management team to be able to grab visualizations I create and put them into presentations, documents, and any format. We give information to legislators and constituents. Grab and go is a must-have.

WALTER's profile image Profile Picture

Power BI User on 05 Jul 2020 22:41:21

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

This is one the biggest limitations IMO currently. I've had to forego using PBI as a solution because my end users can't simply COPY the table alone and paste into another sheet or email.

WALTER's profile image Profile Picture

Power BI User on 05 Jul 2020 22:40:42

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

Yes, a must have and easy for Microsoft to do. Come on guys, this makes no sense.

WALTER's profile image Profile Picture

Mitsu Madhani on 05 Jul 2020 22:38:09

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

This is a must have. Our clients are having to to pivots once the data is exported in excel , which as stated in the comments defeats the purpose .

WALTER's profile image Profile Picture

Dan Malagari on 05 Jul 2020 22:36:38

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

I agree with the rest of the comments. I need to be able to export this matrix to other people in the same format. Having to re-pivot defeats the purpose.

WALTER's profile image Profile Picture

Pelle on 05 Jul 2020 22:36:08

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

I have to send the matrix result to a quality register in an excel file and
Copying the matrix table "as is" is a must in this case.

WALTER's profile image Profile Picture

Tim on 05 Jul 2020 22:36:08

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

All of my dashboard users require the exported format to match the dashboard style...this is a must have!

WALTER's profile image Profile Picture

Tilly Evershed on 05 Jul 2020 22:35:08

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

I agree this is a vital addition to making my users take this product seriously. The format does not need the background data, just a fixed representation would work for my users.

WALTER's profile image Profile Picture

Chris Rue on 05 Jul 2020 22:29:47

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

Agree, this really is a key feature as the distribution of Power BI is pretty restricted cross-companies. Internally, Power BI has increased our efficiency, but without an easy way to get the data into other deliverable formats, it is only so helpful.

Merged Idea (1)