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

Grant Bertoli on 06 Jul 2020 00:16:39

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

This is the biggest deficiency I see with Power BI, 4,000 votes!!!!. End users need to quickly be able to cut and past into excel.

Until this happens I am still building functions in excel from the ground up.







WALTER's profile image Profile Picture

Moath Al Jammaz on 06 Jul 2020 00:16:23

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

since 2016 people asked for this and around 4000 votes, now almost we are in 2021, every month I update so hopefully Microsoft added this, till now it didn't

go to hill Microsoft

WALTER's profile image Profile Picture

Gail Sander on 06 Jul 2020 00:16:21

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

Please add this feature! Even if I could export to PDF and show the ENTIRE matrix instead of just one page would be helpful.

WALTER's profile image Profile Picture

Power BI User on 06 Jul 2020 00:16:16

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

Going to pile on here...so needed!

WALTER's profile image Profile Picture

Fred Kaffenberger on 06 Jul 2020 00:16:12

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

We need this, but here are two more workarounds, just for fun.
1. Create a table with the same format that the matrix exports in Power BI, open the analyzer and copy the dax query and then connect to the datasource in Power BI Report Builder. Build a matrix there, and export that directly. You may have to add sort column as a row above the column headers to get them to sort. Export of matrix works perfectly from Power BI Report Builder.
2. Analyze in Excel the report. Build a pivot table from the live data model. The advantage of this solution is no export to excel is needed.

WALTER's profile image Profile Picture

Power BI User on 06 Jul 2020 00:16:04

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

This is a huge missing in Power BI. You should be able to create an XLSX export beyond a simple CSV.

WALTER's profile image Profile Picture

Power BI User on 06 Jul 2020 00:16:01

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

Add this useful feature

WALTER's profile image Profile Picture

Power BI User on 06 Jul 2020 00:15:53

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

Really need this feature please!

WALTER's profile image Profile Picture

Zohar Solomon on 06 Jul 2020 00:15:49

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

please add this feature

WALTER's profile image Profile Picture

MArce on 06 Jul 2020 00:15:47

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

and I hope they consider the export of the matrix as is on the screen to excel. Dumping thousands of rows from an aggegated visual is dumb.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/34526479-allow-export-of-summarized-data

Merged Idea (1)