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

Tara Busser on 31 Aug 2020 08:58:03

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

Really needed, people want to export the Matrix overviews and just get something they dont understand or have to use PivotTable in Excel to try and get what they need. Not really customer friendly or "i don't know how excel works"-friendly ;)

WALTER's profile image Profile Picture

Tanya Johnson on 28 Aug 2020 20:16:00

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

This is the biggest complaint we get from our end users and the suggested workaround is cost prohibitive for small agile teams. Please make this a priority, it will help so many of us!

WALTER's profile image Profile Picture

Andy Corson on 28 Aug 2020 10:32:02

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

Sorry, and forgot to add, this is THE most requested feature from my users - second only to having the ability to rearrange a report columns and rows, which I saw is now possible in preview.

WALTER's profile image Profile Picture

Andy Corson on 28 Aug 2020 10:29:35

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

For me this is way more important to have than the actual paginated reports. Paginated reports are tedious to format and build. The only reason I would build one is just to export the data in the same form as the visual. If this were possible natively in PBI, I wouldn't even need paginated reports.

WALTER's profile image Profile Picture

Evgeny Utkelov on 27 Aug 2020 09:23:52

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

we really need this functionality

WALTER's profile image Profile Picture

Haley Vest on 26 Aug 2020 14:43:57

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

This functionality is available in Tableau & QlikView. You would think this would be easy for Microsoft since they own Excel.

WALTER's profile image Profile Picture

Michael Comer on 25 Aug 2020 17:13:45

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

Please Microsoft.

WALTER's profile image Profile Picture

Leah Schneider on 18 Aug 2020 19:29:26

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

How does the 8th most popular idea still need votes?

WALTER's profile image Profile Picture

Karthick K on 18 Aug 2020 12:46:46

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

Much needed one.

WALTER's profile image Profile Picture

Derek OBrien on 12 Aug 2020 21:24:14

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

All I can say is that I agree with all the other members, plus, Tableau can do it as we speak.

Merged Idea (1)