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

76fe0bc8 ac33-4265-9115-a5e9c3104c68 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

bf79304c 23cb-4bfd-8764-276eb12cf2e7 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

163f7e30 9402-4800-b967-3c21bd2089f4 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

8638e886 aa9a-4570-85b0-1327b6ac5eb8 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

580e7917 fdb5-4f70-bc14-fa5065993965 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

d731780a 9eb9-4846-be2f-d5a8ed96be0f 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

5c9ad6f7 d261-46f6-9abc-0a866d3e601d 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.

WALTER's profile image Profile Picture

935d95da 62a3-4e02-bbcd-1579ec9f5536 on 06 Jul 2020 00:13:33

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

this is very important feature to add in, pls add!!!!

WALTER's profile image Profile Picture

8dbee5fe 2b73-4437-8e71-e28e090d734a on 06 Jul 2020 00:13:28

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

please do it, for god sake we are asking for this since 2016 is that hard to implement that 4 years past and we still didn't get it!!!

WALTER's profile image Profile Picture

8c592fa4 478c-4ceb-9893-98f3ba9f3c31 on 06 Jul 2020 00:13:27

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

Please develop this feature.