Skip to main content
Microsoft Idea

Power BI

Needs Votes

Enable 'total row' also to be exported.

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

Chandra Vadana Rajamohan on 18 Jan 2022 11:45:55

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

You can perform formatted export to Excel and PDF including the totals and subtotals using Inforiver. Check out this video. You also have extensive Excel-like cell, row and column formatting which gets preserved on export.

's profile image Profile Picture

Aeisha Vyas on 22 Sep 2021 17:21:04

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

Hi, I have clients who can definitely use it for totals and subtotals.

's profile image Profile Picture

Lisa Cuscuna on 23 Aug 2021 14:52:46

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

Are 582 votes not enough?  Please re-consider, as this is greatly needed.  Thank you!

's profile image Profile Picture

Thomas Alger on 16 Jul 2021 14:51:27

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

How has this been an issue since 2017? this needs to be fixed!

's profile image Profile Picture

Himanshu Malhotra on 28 Apr 2021 10:02:42

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

Yes please allow the total to be exported as well. It'll surely reduce a lot of time in adding the totals in excel and then analyzing the data.

's profile image Profile Picture

Jason Campbell on 27 Feb 2021 15:15:22

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

Yes, remove the dependency on Report Builder/SSRS for custom exports. It doubles the amount of work!

Please add xml that will allow users to export formats, too. This feels like a fundamental feature on many levels. Two that come to mind is 1) PBI and Excel are MS products! 2) Excel is generally (largely) compatible with >50% of the apps in existence (even outside of MS), but not really with a Microsoft Business Intelligence app.

There are gaps and there are canyons.

Create a poll in the blog or in the Power BI subreddit for this so that developers don't have to come here to find it.

's profile image Profile Picture

Ramana Sirammagari on 01 Feb 2021 10:29:26

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

Exporting to excel should be provided for grandtotals and subtotals being both are microsoft products i'm not sure how come Microsoft does not provide such a simple excel future when SSRS is able to provide the same, we can't have two different products for one report,Adding this will provide business users an ability to get the data as is what they see on the screen

's profile image Profile Picture

Jevon Low on 03 Dec 2020 06:34:00

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

please enable this - this is really critical otherwise really defeats the purpose of powerbi when we use measures to compute complex aggregations

's profile image Profile Picture

Marc MOURA on 25 Nov 2020 14:31:41

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

I don't understand how this simple request is not fixed yet...
Thanks by advance for fixing it, that's a very useful fonctionnality!!

's profile image Profile Picture

Denis Woods on 31 Oct 2020 08:31:07

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

Will not let me vote, why are Microsoft ignoring this most requested idea?