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

2d6a235c 7918-4c45-a297-646677ada369 on 06 Jul 2020 00:13:24

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

Hi, This is very import features for our customers to export data in matrix format as our traditional reporting tool was supporting this. Can you please let us know as when this will be available in Power BI?

Thanks,
Nalini

WALTER's profile image Profile Picture

9fe3b436 1ad2-4adc-b2b1-df65640f5304 on 06 Jul 2020 00:13:22

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

'@microsoft - can we get an explanation as to why this will not be worked on and no time timetable? There is sooo much pent up demand for this feature from customers.

You should see the expression of the common user go from this product is awesome to, wait, this won't export in the right format? It is the face you get when you find a hair in your food at a restaurant.

This is number one thing I tell people now to manage their expectation on PBI. They usually go a different route knowing PBI does not have this functionality for end users.

WALTER's profile image Profile Picture

ed3190c7 f501-49bf-840d-1d417c324576 on 06 Jul 2020 00:13:21

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

Please, this is really required and have been available in products such as Qlikview for ages...

WALTER's profile image Profile Picture

86374178 0710-4ec2-bd81-6990bbf73f3b on 06 Jul 2020 00:13:04

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

Please enable this feature as users want to export the data from Visual to Excel in pivot form

WALTER's profile image Profile Picture

f813ceec 7140-4684-b791-aec98f46794d on 06 Jul 2020 00:12:51

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

Please enable this option of Matrix Data export to Match PBI, Whereas Other Competitors like Qlikview & Tableau has this beautiful feature which is very much needed.

WALTER's profile image Profile Picture

7b63c4fd 1949-483a-9e7e-0b33f3bfec1f on 06 Jul 2020 00:12:46

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

Needed this feature.

WALTER's profile image Profile Picture

1415882d 3342-4c52-ace7-b79f18716940 on 06 Jul 2020 00:12:46

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

Please develop - greatly needed for the common PBI report user...

WALTER's profile image Profile Picture

63af6af8 9a7b-4c7b-a9c7-f399ced56adf on 06 Jul 2020 00:12:44

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

Please. Seriously.

WALTER's profile image Profile Picture

8d6d668d cebb-4628-b6ed-54b81e1740eb on 06 Jul 2020 00:12:29

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

Really needed function

WALTER's profile image Profile Picture

bc2e3fe0 36fb-4b8d-8f6b-1aebbc7f45d8 on 06 Jul 2020 00:12:21

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

BI Helper Matrix 4.0: The complete solution for formatted data export of table and matrix visuals

Go to https://bihelper.tech/bihelper_matrix.html.

Visual formatting and matrix data pivots retained in Excel download.

Secure Microsoft login - use your Power BI login to access Matrix 4.0.

Free 14 day trial.