Exporting "large" matrix visual

[AlB]

Hi all,

We have created  a matrix visual with some 30K rows  (and 6 columns) when expanded fully. I've just tried to export it to csv but I get a warning as depicted below and the export is truncated heavily.  Two questions:

1. Does anyone what the exact limit is? Is it bytes, rows... and how much?

2. Is there a way to circumvent this and export all the data in the matrix visual?

Many thanks

[v-xulin-mstf · Accepted solution]

Hi @AlB,

Here is the Limitations and considerations:

As a workaround, you can export data from paginated reports with Power Automate if you have a premium license.

You can also use Analyze In Excel with pro license.

In addition, by installing Analyze in Excel for Power BI Desktop , you can install a dedicated external tool that creates an Excel file connected to the data in the Power BI Desktop model, and it is entirely free.

Best Regards,

Link

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.