Forum Discussion
Unable to export underlying data into excel
Hi Anonymous
Please check if the data or the matrix visual has hit some limitations of exporting underlying data feature.
Community Support Team _ Jing Zhang
If this post helps, please consider Accept it as the solution to help other members find it.
Hi v-jingzhang,
Thanks for your reply.
I can't see anything that stands out in the limitations. I have tried filtering it so it is only <100 rows of data and it still creates that error, so I can't imagine that the 16MB size is the issue here.
There may also be too many columns in our dataset, but the export underlying data works for other graphs - just not the matrix, which makes me think that's not the issue either. These are the only things I could see would be affecting it from that page you linked.
Anonymous
Do you have other matrix visuals in your report? If so, can these matrix visuals export underlying data? If not, you could add a matrix visual into it and test this. You could also test when a matrix only contains data from a single data table, whether it can export underlying data.