Skip to main content
Microsoft Idea

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

Bill Breitenbach on 11 Sep 2020 18:58:27

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

The ability to export a matrix visual as it was created is essential to presenting the data in a logical fashion.

WALTER's profile image Profile Picture

Ingrid Rodríguez on 09 Sep 2020 16:40:27

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

To the people asking for a third party workaround I found BI Helper (bihelper.tech). Search for the Matrix Solution. It's not free tho but with the demo I can tell it's great

WALTER's profile image Profile Picture

Marta Simon on 03 Sep 2020 19:51:03

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

Being able to carry the boards would be great. Not being able to do so transforms this tool into an excellent one, since when exporting the information the data must be worked from scratch.

WALTER's profile image Profile Picture

Hector Mancilla on 31 Aug 2020 21:51:57

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

(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.)

it is really maddening that they do not realize that this development is for the end users who are the ones who occupy the bi. It is really frustrating to explain that something so logical does not work in power bi, considering that it is also a microsoft program just like excel.

WALTER's profile image Profile Picture

Hector Mancilla on 31 Aug 2020 20:50:49

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

por favor, necesitamos esto...

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

Merged Idea (1)