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

1a9da916 2fa9-46e9-94cc-f6182c6d9535 on 05 Jul 2020 23:01:39

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

Agreed, better export options would be huge.

WALTER's profile image Profile Picture

ccf04853 7c71-49d2-b98c-b7f0671419a8 on 05 Jul 2020 23:01:34

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

Agree to below comments, this is Need To Have

WALTER's profile image Profile Picture

4566ca83 9b76-424f-ab62-6388f3d44c7e on 05 Jul 2020 23:01:30

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

pls implement , it will be a great help

WALTER's profile image Profile Picture

124872d0 4e34-4064-b154-b1f8b1e78181 on 05 Jul 2020 23:01:09

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

please do!

WALTER's profile image Profile Picture

407fb206 ca28-43c7-b4f5-b9daf30de98a on 05 Jul 2020 23:01:08

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

Pls implement this already.

WALTER's profile image Profile Picture

46fbe9d5 c3dd-471c-9e47-09fb6dd8c880 on 05 Jul 2020 23:00:29

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

please do add this functionality!

WALTER's profile image Profile Picture

b9a0b93f 8323-4315-ac7e-a0a17dce531e on 05 Jul 2020 23:00:22

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

Incredible that this has not been implemented yet..

WALTER's profile image Profile Picture

28401fee a134-4e13-a6da-c336ecc8e63f on 05 Jul 2020 23:00:13

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

It is absolutely shocking that this feature is not yet enabled.

If your graph or matrix contains a ratio - e.g. a growth rate - and you graph or matrix has more than one field in the axis/column, you simply CANNOT recover the ratios shown in the powerbi graph/matrix, from the excel output.

So if the user wants to export the ratios they see in the graph/table - THEY CANNOT!!!!

THIS IS LEVEL 1 ON BUSINESS INTELLIGENCE

WALTER's profile image Profile Picture

28401fee a134-4e13-a6da-c336ecc8e63f on 05 Jul 2020 23:00:13

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

It is absolutely shocking that this feature is not yet enabled.

If your graph or matrix contains a ratio - e.g. a growth rate - and you graph or matrix has more than one field in the axis/column, you simply CANNOT recover the ratios shown in the powerbi graph/matrix, from the excel output.

So if the user wants to export the ratios they see in the graph/table - THEY CANNOT!!!!

THIS IS LEVEL 1 ON BUSINESS INTELLIGENCE

WALTER's profile image Profile Picture

0faf72be 6f71-4f71-bdc5-a51121240eb1 on 05 Jul 2020 22:59:57

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

Function really needed, I have a simple hierarchy but need to send the report as shown in PBI and I can't