I have a data set that contains ~4 million rows. The visual component I am using is a Matrix visual. After selecting the data I need, the Matrix visual is 150 rows and 25 columns. I would like to export this into a csv 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 my data set is too big.
Is there a way of exporting the data in this format, or perhaps a python / R script that can gain access to the data the visual is using?
Any help appreciated, Thanks in advance
1 Answer
Exporting data as is from a matrix, is not supported. However, it is planned and you can vote for it, if you want to. You can only export the underlying data, but you obviously reached it's limits.
What you can do, is to connect from Excel to your data source and create a pivot there, the same way as your matrix in Power BI.
1
