Power BI

Needs Votes

Enable 'total row' also to be exported.

Vote (462)

on 05 Jul 2017 02:56:06

Now when we export data from matrix visual in PBI Desktop to an Excel file - the 'Total' row does not get exported to Excel though that is visible in PBI Desktop. Please fix it.

Comments (76)

Comments (76)

45f3aef2 e5a5-40ff-8ac7-eeebc97919a8 on 06 Jul 2020 00:03:24

RE: Enable 'total row' also to be exported.

Together with this option, can you allow the title to be exported as well?

4a9da861 e8f5-4658-8a69-f669550ad2ce on 06 Jul 2020 00:03:14

RE: Enable 'total row' also to be exported.

This would be very helpful if the export could match the visual

dc7163b3 2451-4de2-a9ca-5892a42736e5 on 06 Jul 2020 00:02:15

RE: Enable 'total row' also to be exported.

I agree, this is very disappointing this it not out of the box. I understand theory they want PBI to be an end product and not use excel however they really don't understand how users need to use the data and this results in significant manual work to copy totals. Defeats efficiencies that it is meant to promote. Many of our users refuse to use PBI because of this silly issue and are using competitor tools until it is fixed. It also currently can't do anywhere near as easily or quickly what can be done in excel or with as much control. Until PBI can provide better flexibility and ease of use, people will stay on excel and it won't replace it.

84fa0825 953d-490e-a3cb-3faabcfbe9d0 on 05 Jul 2020 23:59:08

RE: Enable 'total row' also to be exported.

Please add this functionality, end users are always having some reasons like this to hate or adjust to PBI

840e2b2e 4945-43b7-81da-9beb51b52339 on 05 Jul 2020 23:58:53

RE: Enable 'total row' also to be exported.

It's crucial. Please add ASAP

b962767a 5528-41bd-accf-6a7061edfe92 on 05 Jul 2020 23:58:37

RE: Enable 'total row' also to be exported.

Please add total it is must

70c161c6 3ec8-4653-8ae9-5a4f66754bdb on 05 Jul 2020 23:58:37

RE: Enable 'total row' also to be exported.

Export grand total is a key function. Please fix it.

2c8c308c 4f94-4f0e-a00f-5697c8157d88 on 05 Jul 2020 23:58:37

RE: Enable 'total row' also to be exported.

How is this not already built? This is incredibly frustrating. At least allow me to copy and paste the numbers in my visualization if you're not going to let me export Total columns. There are a million use cases for this feature.

85a752bf 38a1-4146-beca-bda95f0bde3e on 05 Jul 2020 23:57:02

RE: Enable 'total row' also to be exported.

Please MS add this ASAP, that's a total must for people that need to export data and save them in a daily basis

799cc980 11c3-4678-b04e-2fca08ca8b47 on 05 Jul 2020 23:56:33

RE: Enable 'total row' also to be exported.

Yes please fix exporting sub and grand totals.