Skip to main content

Power BI

Needs Votes

Allow Table and Matrix Data Exports to Match PowerBI Visual

Vote (4721) 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 27 Jul 2020 18:00:47

Thanks for your feedback on this issue - while we'd like to enable this, there is currently no timetable around doing so. There is the option as a workaround the create a paginated view as a drillthrough of the visual and have a formatted version you can export to Excel, but understand this isn't a solution everyone can take advantage of currently.

Comments (692)
WALTER's profile image Profile Picture

22023a59 8173-491b-8dc9-c5317ebf249d on 05 Jul 2020 22:42:05

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

I have several clients that need this requirement

WALTER's profile image Profile Picture

badeec05 5c74-ea11-a811-000d3a579c39 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

dbc6cc36 6836-4390-9517-b5f0b3d0ca69 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

becab309 409d-4286-9e9a-4abd9ae02456 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

011d7652 752f-4064-8d23-92601eda48bd 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

b032b6a6 4405-4366-9594-68b579b912f2 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

a0aeabda 4a7a-4f45-9743-973a0b817965 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

ca9391b7 908a-4d23-af06-b473de1b8abf 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

bedcc31d d526-433e-9b77-39e59f9fd1ad 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

d6f4ac29 20d3-496f-b97e-da29c083da0e 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.