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

    95ce9c36 8fb3-4f2b-a593-7b724b3e952d on 06 Jul 2020 00:17:00

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

    where are the totals and subtotals on my excel exported file?? need it ASAP!!

    's profile image Profile Picture

    12732bc6 8137-4588-b80d-05fdafaaa333 on 06 Jul 2020 00:16:12

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

    This is a basic. Power BI has so much visual power and pitiful data exporting ability.

    's profile image Profile Picture

    31adb879 20b7-4879-864e-865f67b52e2c on 06 Jul 2020 00:13:48

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

    Please add feature of subtotal and grand total rows to be exported as well.

    's profile image Profile Picture

    44acb831 8da8-46e4-ab2e-5be7a7dbc3c5 on 06 Jul 2020 00:13:34

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

    Everyone needs a totals row. This should be a top priority fix.

    's profile image Profile Picture

    b9ebb1cd bd44-44e7-9f30-9ce332542c85 on 06 Jul 2020 00:13:06

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

    Please enable 'total row' and also 'subtotal row' to be exported.This is a necessary requirement so Power BI can meet all of my reporting needs.

    's profile image Profile Picture

    e75ce1d8 5387-488e-adc8-0b2eac229ed1 on 06 Jul 2020 00:12:50

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

    The 'Total' row does not get exported to Excel though that is visible in PBI Desktop. Please fix it
    please trying to resolve this as soon as possible

    for workaround we are using below information

    we are using "Analyze in Excel " option found in power bi Services we can use this option so we get all data and calculated fields in excel.

    's profile image Profile Picture

    19835709 da68-4856-8dba-5d93ce218fef on 06 Jul 2020 00:12:31

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

    Please enable to export subtotals and totals to excel

    's profile image Profile Picture

    52baa442 0417-468b-ba9a-df2e28002154 on 06 Jul 2020 00:11:31

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

    This is a MUST have, we need WYSIWYG behavior on table reports in PBI service!

    's profile image Profile Picture

    1f22847d a39c-4883-a00c-86a24949718d on 06 Jul 2020 00:11:21

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

    Export subtotals and grant totals for a matrix is extremely importat for a report built on Power BI.
    What you see should be what you get exported.

    's profile image Profile Picture

    a3309361 99be-ea11-a812-000d3a8ddfb2 on 06 Jul 2020 00:09:24

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

    This is very important, make a fix for this error.
    Users themselves cannot correctly calculate complex totals