Power BI data to large to export from matrix visual component

[ibazghadze]

I have a data set that contains ~2 million rows. The visual component I am using is a Matrix visual. After selecting the data I need, the Matrix visual is 75000 rows and 30 columns. I would like to export this into a xlsx in the exact way it is shown in the Matrix. When I try exporting the data set via the export data option in the menu, I get a message indicating that Exported data exceeded the allowed volume. Some data may have been omitted..

Is there a way of exporting the data in this format?

Any help appreciated, Thanks in advance

[Greg_Deckler]

@ibazghadze I think the row limit is 50,000 if I am not mistaken. Perhaps publish to the service and use Analyze in Excel to recreate your matrix as a pivot table?