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

avraam 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

Power BI User 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

Power BI User 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

Power BI User 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

Javier Hernandez 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

WALTER's profile image Profile Picture

Power BI User on 05 Jul 2020 22:59:49

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

This is much needed functionality,

WALTER's profile image Profile Picture

Tulio Alcantara on 05 Jul 2020 22:59:35

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

Please increase this function

WALTER's profile image Profile Picture

Felipe Correa on 05 Jul 2020 22:59:26

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

Please. Enable this!

WALTER's profile image Profile Picture

Power BI User on 05 Jul 2020 22:59:18

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

my vote

WALTER's profile image Profile Picture

Marcus Sia on 05 Jul 2020 22:59:16

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

please please please enable this. I think my company may dump power bi soon if this is not implemented.

Merged Idea (1)