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

Matthias Richter on 06 Jul 2020 00:14:30

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

Our main use case is the distribution of data and the data visualization to our customers throu our homepage. With Tableau it is supereasy to do, it is elegant and user friendly designed to download the visual als a png-picture, powerpoint-sheet or as a pdf-document and you can get the data in csv-format.
In PowerBI we have to teach our customers to hover over the visual, to see and select the visual header so they can find the data export option.
This is really anoying! Pease add this feature and optimize the download-options on every plattform!

WALTER's profile image Profile Picture

Power BI User on 06 Jul 2020 00:14:26

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

Tableau does this very easily for all the matrix tables that I have. Very frustrating to not be able to do the same using Power BI.

WALTER's profile image Profile Picture

Sami Phoenix on 06 Jul 2020 00:14:14

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

Come on, please add this feature. This is basic stuff and is a huge pain for users to reformat the data in Excel. Sort it out.

WALTER's profile image Profile Picture

Power BI User on 06 Jul 2020 00:14:04

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

Please add this feature. It would be super helpful for my 100+ users.

WALTER's profile image Profile Picture

Power BI User on 06 Jul 2020 00:14:04

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

Please add this feature!

WALTER's profile image Profile Picture

Brian_M on 06 Jul 2020 00:14:01

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

This is a major disappointment with the Power BI Service. Many simple web pages and sql reports allows the viewed data to be exported to excel with the same formatting. I really do hope this improvement can be deployed soonest as without this many customers are losing interest in Power BI.

WALTER's profile image Profile Picture

Tom Bailey on 06 Jul 2020 00:13:53

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

I cant believe this hasn't been developed considering the idea itself is 4 years old. This makes it difficult to use Power BI over tableau for my business.

WALTER's profile image Profile Picture

Matteo on 06 Jul 2020 00:13:50

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

This is a fundamental feature... expecially for my colleagues with Mac device that cannot use powerquery in their Excel

WALTER's profile image Profile Picture

Power BI User on 06 Jul 2020 00:13:44

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

When power bi can export matrix table to excel

WALTER's profile image Profile Picture

Anne Corall on 06 Jul 2020 00:13:44

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

Our customers ask for data to export in a matrix format regularly and when I tell them it can't, they find the tool to be a waste of time to reformat. Being able to export a matrix in the same format it appears in the visual would greatly improve our customers' experience.

Merged Idea (1)