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

11332b17 88bc-4cd9-9bc5-35a8080c7805 on 06 Jul 2020 00:10:33

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

This request is really a MUST for most of us users! Really a big limit for PowerBI.

WALTER's profile image Profile Picture

3471b32b e34c-4401-bc27-923ba0f84af0 on 06 Jul 2020 00:10:13

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

This would be extremely helpful for my organisation, thanks!

WALTER's profile image Profile Picture

d8111ddb 8dbb-4547-9f3d-3807061ac2df on 06 Jul 2020 00:10:11

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

Please add it, this is very needed!

WALTER's profile image Profile Picture

28c026d9 3865-4e88-949c-3a67028dc98f on 06 Jul 2020 00:10:09

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

This is a serious limitation which is causing headaches for our customers and support teams. I hope Microsoft escalates this for a solution soon.

WALTER's profile image Profile Picture

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

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

This is solved - BI Helper Matrix is a Chrome extension for table and matrix data exports from Power BI.

Go to https://bihelper.tech/bihelper_matrix.html to download and test the solution.

WALTER's profile image Profile Picture

8da4950f 1899-4d78-bf22-0ba7d6536c43 on 06 Jul 2020 00:10:08

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

Please don't say it is solved by Chrome extension called BI Helper Matrix. I don't want to use Chrome and i can't ask my clients to use Chrome. MS needs to come with a solution within Power BI Desktop/service.

WALTER's profile image Profile Picture

a818f71b b7be-4860-b95c-91fb61bc78be on 06 Jul 2020 00:10:07

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

At present, we have to use other tools to share dashbord data.
We need export matrix data.
Please improve Power BI.

WALTER's profile image Profile Picture

1e75502c 562c-4d2d-ba0b-4cacf3e28b90 on 06 Jul 2020 00:10:00

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

please add this ASAP very dissapointing!

WALTER's profile image Profile Picture

6de00723 61ab-474f-a3eb-a579b5723040 on 06 Jul 2020 00:09:58

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

It's a shame on Microsoft that not able or not like to realize a basic feature after 4 years of complaints of their customers.

WALTER's profile image Profile Picture

4d69ac4c 89b7-4cdc-884b-74b6c08b9d6d on 06 Jul 2020 00:09:53

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

I agree, This is a basic feature expectation from Microsoft. Otherwise, we have to think about other products