Power BI

Needs Votes

Enable 'total row' also to be exported.

Vote (690)

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 (88)

Comments (88)

Scott Eguires on 06 Jul 2020 00:04:46

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

This needs to be a priority.

Drei on 06 Jul 2020 00:04:05

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

Please fix this.

Lana Shulga 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?

Alison Clowes 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

Tim K 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.

Power BI User 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

Aliaksei Nekrakha on 05 Jul 2020 23:58:53

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

It's crucial. Please add ASAP

akshay on 05 Jul 2020 23:58:37

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

Please add total it is must

Power BI User 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.

ryan 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.