Forum Discussion

ibazghadze's avatar
ibazghadze
Frequent Visitor
2 years ago

Power BI data to large to export from matrix visual component

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

Need Help

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    2 years ago

    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?