Forum Discussion

wenchi's avatar
wenchi
Helper I
4 years ago

Export data with error

our user report an error when trying to export data from matrix to Excel file. The matrix has two levels on  the row (not pre-built hierarchy). When all rows are collapse and it was fine to export by...
Need Help
v-chenwuz-msft's avatar
v-chenwuz-msft
Community Support
4 years ago

Hi wenchi ,

 

I have test my matrix table export to file by choose "data with current layout" and it work fine. Maybe you can republish the report and try it again. Please make sure there is a unique key in the table of the model.

 

I also found a similar problem being solved, which you can refer to.

https://techcommunity.microsoft.com/t5/microsoft-teams/issues-exporting-power-bi-data-from-embedded-reports-in-teams/m-p/3032695 

 

Best Regards

Community Support Team _ chenwu zhu

 

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

 

wenchi's avatar
wenchi
Helper I
4 years ago

The report is connect to Azure AS model using live connection. I have 2 levels on the rows plus 12 measures to display. If i collapse all levels on the row, the data exported just fine. If i exapnd one or two nodes, then i got the error. After numerous testing, i can export to excel if i reduce to 4 measures with few nodes expanded on the row. It seems the limitation of resource to execute the query? I don't quite understand why it's fine to export when collapse all nodes. The number of rows being exported is less than 200 rows if expand all levels.

 

Wenchi