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

cbozart on 05 Jul 2020 23:32:52

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

I need my users to be able to export the matrix they see and not be required to know PowerPivot to use their data!

WALTER's profile image Profile Picture

Power BI User on 05 Jul 2020 23:32:51

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

It is absurd that a microsoft tool cannot export a summarized matrix to excel when all the other BI tools can do it.

WALTER's profile image Profile Picture

Power BI User on 05 Jul 2020 23:32:32

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

Agreed, this is a must-have feature for our users.

WALTER's profile image Profile Picture

Power BI User on 05 Jul 2020 23:32:22

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

I also agree that this feature is absolutely necessary.

WALTER's profile image Profile Picture

Power BI User on 05 Jul 2020 23:31:59

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

Please, we need this!
Did all the work to get this particular function that i assumed was integrated.

WALTER's profile image Profile Picture

Aleksandr on 05 Jul 2020 23:31:59

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

This feathure is a 'must have'. Our users are unhappy because they can't export their matrixes "as is".

WALTER's profile image Profile Picture

Connie Corredor on 05 Jul 2020 23:31:29

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

This is a critical feature for our business users. Many want to export the matrix(pivot) as we built it in power bi via excel or pdf. The only option available in the web is to export to excel and then the matrix format is not even there for them. The assumption that everything will be done within power bi is not reasonable. Users will always want to export what they see and even the Export PDF feature that came out in August is only available in desktop. I also tried the power bi export feature on the web and that too falls short - this feature does not provide the entire graph of the data - only a picture so if your data scrolls down, you only see the first part of the screen.

WALTER's profile image Profile Picture

Glen Hunt on 05 Jul 2020 23:31:17

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

Me too. Can't believe that such a simple function isn't available. No point trying to do clever stuff if basic stuff isn't supported

WALTER's profile image Profile Picture

Power BI User on 05 Jul 2020 23:31:11

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

Very frustrating that I cannot export the visual to Excel - instead the information that is imported is simply not usable.

WALTER's profile image Profile Picture

Power BI User on 05 Jul 2020 23:31:01

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

yes, this function is necessary...

Merged Idea (1)