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

Ashish Dhone on 28 Jan 2023 21:21:22

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

WALTER's profile image Profile Picture

Ashish Dhone on 28 Jan 2023 21:21:05

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

test

WALTER's profile image Profile Picture

782661a8 5df4-ea11-a815-0022481cfe77 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

e330fd89 baf2-ea11-a815-000d3a563be2 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

56070c8d 1dee-ea11-a817-000d3a8faea9 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

8e51ae6a cbeb-ea11-a817-000d3a8faea9 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

8e51ae6a cbeb-ea11-a817-000d3a8faea9 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

91f3cb64 b6d0-ea11-a812-000d3a579c34 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

5f1bbfb0 ac7a-4d46-a752-bb4f21b2a615 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

368cb1b2 3dcc-4abc-b3e8-dfc8261623a4 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.