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

    5d280176 aa9e-4aa3-a0b1-a6eb344938f1 on 06 Jul 2020 00:09:01

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

    Power BI runs reports, not for data dump. Total is a critical part of a report, a must have element. Please make it exportable.
    Thank you!

    's profile image Profile Picture

    a3998d99 1562-47db-8aa2-3888bc34ce78 on 06 Jul 2020 00:08:39

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

    Why oh why is this not available?

    's profile image Profile Picture

    a5b105f0 05df-4d6d-9a83-3774d282816f on 06 Jul 2020 00:07:58

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

    Please include this. My firm's reporting metrics rely on PowerBI. This functional issue has caused a significant bottleneck, resulting in lower synergies awarded by the software. Clients not happy!

    's profile image Profile Picture

    8c21e250 feec-48f2-9954-06636cdb929c on 06 Jul 2020 00:07:30

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

    Hope this issue will be fixed in the recent releases.

    's profile image Profile Picture

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

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

    We also need this solved asap for matrices and flat tables. There are reports which have to be exported to Excel including totals. Thx.

    's profile image Profile Picture

    37d12411 c7f4-4e92-9a64-30bce7b4c1c6 on 06 Jul 2020 00:06:05

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

    Same when we export from Power BI Service, and not only matrix - plain tables should have this feature as well.

    's profile image Profile Picture

    9724ae65 1c0e-4f9c-a9fd-0ef6762c7d2a on 06 Jul 2020 00:06:00

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

    We need this asap. Please fix

    's profile image Profile Picture

    f6032d44 e9c3-4ff9-afff-bfe47293035d on 06 Jul 2020 00:05:15

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

    I am using Direct Query per client needs/request. Only one table is used for this instance. There are NO other tables or relationships.

    I have 3 visuals on the screen:

    A Slicer so the user can specify a date range, a Card to display the count of rows, and the Table visual to allow the user to see and export the data.

    The data being exported is missing data (rows).

    The count as displayed in the Card visual is correct (verified using SQL Server Management Studio).

    The total rows for this scenario is 8,172.

    When I export to CSV, the total row count is 8,155.

    This data is need for reporting requirements per federal regulations.

    It really needs to be accurate...and consistent.

    I recommended the client use Power BI instead of Tableau.



    's profile image Profile Picture

    b572ed35 8bf4-4eca-9f40-7b613c98cf66 on 06 Jul 2020 00:04:46

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

    This needs to be a priority.

    's profile image Profile Picture

    7147e9b3 afbe-42c5-8b49-978c1a3afb8a on 06 Jul 2020 00:04:05

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

    Please fix this.