Skip to main content

Power BI

New

Download an Excel file in Matrix Format (not normalized)

Vote (43) Share
's profile image

on 03 Apr 2017 22:13:18

So I have a matrix table setup, works fine. But when I have my users download the matrix as an Excel file, the downloaded data is no longer presented in the same way as the matrix.

The data has been normalized, which means the users will have to re-create the matrix via a pivot table.

It would be really slick if Microsoft did both on download, create a sheet with the raw data (normalized) and created a second worksheet with the original matrix visualization as a pivot table.

But if that's too much, just having a plain table in the original matrix format would suffice.

Comments (2)
's profile image Profile Picture

58c6a4a9 85ff-48b4-89a8-92d1464e59de on 05 Jul 2020 23:29:05

RE: Download an Excel file in Matrix Format (not normalized)

Needed !

's profile image Profile Picture

23ba1643 b428-4de0-a4ac-9431a492160f on 05 Jul 2020 23:03:39

RE: Download an Excel file in Matrix Format (not normalized)

I would also add that from a user standpoint it would be nice for them to be able to also print a matrix table from the service, in a report format, and get multi pages if necessary.