Skip to main content
Microsoft Idea

Power BI

Needs Votes

Enable 'total row' also to be exported.

Vote (690) Share
's profile image

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 (90)
's profile image Profile Picture

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.

's profile image Profile Picture

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.

's profile image Profile Picture

Bruno Artioli 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

's profile image Profile Picture

Power BI User on 05 Jul 2020 23:56:33

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

Yes please fix exporting sub and grand totals.

's profile image Profile Picture

Power BI User on 05 Jul 2020 23:54:44

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

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

's profile image Profile Picture

Brian on 05 Jul 2020 23:53:18

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

Please add this ASAP

's profile image Profile Picture

syed on 05 Jul 2020 23:52:53

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

This is just huge fail and no info when the bug will be fixed? Can someone please take some responsibility for this and update ASAP?

's profile image Profile Picture

shreya on 05 Jul 2020 23:51:42

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

Please fix this.

's profile image Profile Picture

shreya on 05 Jul 2020 23:51:42

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

Its must have. Please fix this ASAP.

's profile image Profile Picture

David Macdonald on 05 Jul 2020 23:50:22

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

This drives my exec users crazy.

They end up calculating the totals themselves in excel, so they start out annoyed.
Then because averaging an average is almost always wrong, they get different results than the totals in PowerBI, which is calculating correctly.

It's too late to teach them statistics 101.

The result is the don't trust PowerBI.