Skip to main content

Power BI

Needs Votes

Enable 'total row' also to be exported.

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

1f86ec42 08de-4f6d-abe9-3298c39f6404 on 05 Jul 2020 23:29:57

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

We plan to migrate to Power BI but this one issue causing us not able to migrate it.
Please provide this option as soon as possible.

's profile image Profile Picture

1eb5a9e4 7e41-4037-b3b4-ebca715e7f8b on 05 Jul 2020 23:27:22

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

When users see the export data from PowerBI to Excel, they complain totals are missing, which they have to do again in excel, ideally it should export the totals.

's profile image Profile Picture

351c890f 2b3c-4270-a0e2-52154110f337 on 05 Jul 2020 23:23:10

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

this will be a very usefull function, please!!

's profile image Profile Picture

95f55415 5fc0-4968-b1b6-fe407b5030d3 on 05 Jul 2020 23:22:10

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

Yes, pls make it so export includes totals row.

's profile image Profile Picture

98d7fd5d 14cd-4f97-a714-a1c928e44f97 on 05 Jul 2020 23:22:00

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

This has been a request for nearly a year now... Really need this feature to push my software forward. This issue and the inability to show TEXT on a dashboard tile has had me a standstill for a year now...

's profile image Profile Picture

a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 23:21:35

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

Truly need this ability in Power BI (SSRS not an option). End Users will not necessarily understand the complex weighted and group-dependent calculations required to derive their own totals once data is exported!

's profile image Profile Picture

a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 23:19:21

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

Please add this feature to the Exports. Clients seem to require this often and it would go a long way to helping make this a bit more streamlined.

's profile image Profile Picture

dae37fd6 5890-464c-ad6f-7166d568a769 on 05 Jul 2020 23:18:07

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

Required this feature, this is a basic need and available in BI Tools like QlikView

's profile image Profile Picture

fac5dbd0 1f0b-e811-8103-c4346bdc7121 on 05 Jul 2020 23:16:39

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

There is no point in showing data in matrix with totals in UI but not being able to export totals in excel.
This is a very much required feature.

's profile image Profile Picture

f8430be0 c0e1-4e01-9815-32852ff34771 on 05 Jul 2020 23:15:42

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

It's very useful option and required for analysis any one had any luck on grand totals or sub totals into excel...