Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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 valu...
Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    3 years ago

    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.

v-yanjiang-msft's avatar
v-yanjiang-msft
Community Support
3 years ago

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.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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