- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Export Data From Matrix
I have a matrix with many columns, including one LARGE text field called Notes. In the matrix visual the Notes column is collapsed because it scrolls infinitely otherwise (permanently hiding any values to the right of it). Since I can't scroll all the way to the right, I can't resize the Notes column either.
That's fine - I have instructions to tell the user to export data from the matrix to view this note field.
However, I am experiencing different results on export.
Export from Power BI Desktop while in the report gives the notes field.
Export from Power BI Web Report View does NOT give the notes field.
How can I allow the user to export with the Notes?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @Anonymous ,
According to the Power BI documentation, the export option Data with current layout preserves the formatting of the visual, including number formatting and grouped (merged or unmerged) dimensions. However, this option is only available in public preview and may have some limitations or issues. One of the limitations is that the maximum number of characters per cell in Excel is 32,767, so if your Notes field exceeds this limit, it may not be exported correctly.
A possible workaround is to use the summarized data or underlying data export options, which export the data as a flat table of rows and columns. However, these options may not preserve the formatting or grouping of your matrix visual. Another option is to use a different visual that can display the Notes field without scrolling infinitely, such as a table or a card.
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @Anonymous ,
According to the Power BI documentation, the export option Data with current layout preserves the formatting of the visual, including number formatting and grouped (merged or unmerged) dimensions. However, this option is only available in public preview and may have some limitations or issues. One of the limitations is that the maximum number of characters per cell in Excel is 32,767, so if your Notes field exceeds this limit, it may not be exported correctly.
A possible workaround is to use the summarized data or underlying data export options, which export the data as a flat table of rows and columns. However, these options may not preserve the formatting or grouping of your matrix visual. Another option is to use a different visual that can display the Notes field without scrolling infinitely, such as a table or a card.
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Choosing the "summarized data" option during Export achieved the result I am looking for. Thank you

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
04-22-2024 06:12 AM | |||
04-18-2024 02:26 PM | |||
11-22-2023 06:38 AM | |||
04-23-2024 01:36 AM | |||
05-24-2022 01:41 AM |
User | Count |
---|---|
141 | |
115 | |
84 | |
63 | |
48 |