Skip to main content

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

Power BI Ideas Admin on 05 Jul 2020 23:08:02

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

Hurry up Microsoft!!

WALTER's profile image Profile Picture

Power BI User on 05 Jul 2020 23:07:09

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

Please implement - required by our business users too.

WALTER's profile image Profile Picture

Power BI User on 05 Jul 2020 23:06:58

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

Really need this feature, it is a major barrier to adoption of the tool at our organization.

WALTER's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 23:06:58

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

This is a huge issue with our business users. Without this i feel like we are implementing half a tool.

WALTER's profile image Profile Picture

Power BI User on 05 Jul 2020 23:06:58

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

It kinda defeats the whole purpose of having these aggregated tables, if you can't pull out the values you produce...

WALTER's profile image Profile Picture

Thomas Kelly on 05 Jul 2020 23:06:25

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

Just found that if I export the table from power BI and create another matrix using qlikview then this matrix can be exported in the format created.

Its using a different product but may save some time whilst we wait for the feature to be made available in Power Bi.

WALTER's profile image Profile Picture

Wim Allegaert on 05 Jul 2020 23:06:14

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

Export matrix data would be very usefull for us.

WALTER's profile image Profile Picture

Thomas Kelly on 05 Jul 2020 23:06:08

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

Really need this feature, i have spent a lot of time creating a matrix to suit our business requirements. Disappointing to find that when exporting, the data is not in the same format as the matrix created. PLEASE CAN WE HAVE THIS ADDED ?

WALTER's profile image Profile Picture

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

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

'+1

WALTER's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 23:05:46

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

Exporting to excel is the only way we can print a large set of data from Power BI. The fact that it does not keep the same format means that for users who lack excel skills they cannot print their data in an appropriate format.

Merged Idea (1)