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

638e0f8a a619-45e7-a0e7-f924559f426f on 05 Jul 2020 22:59:49

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

This is much needed functionality,

WALTER's profile image Profile Picture

61f3c93f e05e-4b2c-81f6-e11fbdcd1114 on 05 Jul 2020 22:59:35

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

Please increase this function

WALTER's profile image Profile Picture

288032c1 64dc-42d5-953f-8cf31866d5b0 on 05 Jul 2020 22:59:26

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

Please. Enable this!

WALTER's profile image Profile Picture

d99c27b9 81b2-445f-8556-52c61ce5a359 on 05 Jul 2020 22:59:18

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

my vote

WALTER's profile image Profile Picture

0703182e f998-44e3-a3a7-e14a313d603d on 05 Jul 2020 22:59:16

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

please please please enable this. I think my company may dump power bi soon if this is not implemented.

WALTER's profile image Profile Picture

dd988e3e 8181-4954-8e3e-d4debb5f3561 on 05 Jul 2020 22:58:50

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

Please enable this feature. Would be great.

WALTER's profile image Profile Picture

06c50411 8637-4bb6-b7a1-34c41f2d30a5 on 05 Jul 2020 22:58:20

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

Not much help to export CSV and create pivot table. Might as well create in Excel one time.

WALTER's profile image Profile Picture

bb3af84e 7e84-4b51-bdf6-2870b74bcdb5 on 05 Jul 2020 22:57:48

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

I just want a same display format in Excel as I can see in BI visual matrix so that I can give it to boss.

WALTER's profile image Profile Picture

8130fd07 60bb-47be-8910-59a6ade098ad on 05 Jul 2020 22:57:12

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

Agreed! I'm spending a ton of time recreating a format in Excel that I can see in PowerBI. Quite frustrating haha

WALTER's profile image Profile Picture

9c16b8e3 00a9-4ac0-96f9-b46dcf063f3f on 05 Jul 2020 22:57:05

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

It would also be very useful to be able to "Ctrl C" Copy and "Ctrl V" Paste from BI to Excel. That is often quicker than exporting.