matrix - export data- summarized data not exporting all data

[Anonymous]

Hello,

I have a PowerBi report which contains a matrix. When the users export the matrix data using the summarized data option not all rows are being exported, there are around 5000 rows in total. Has anyone experienced this?

Thank you.

[karo]

Any news regarding this issue and potential root causes?

We are facing similar issue and none from the link above seems to be applicable in our case. 

Regards, 

Karo

[collinq]

Hi @karo ,

Baased on that article, this is all based on the nubmer of data intersections:

For export from matrix visuals using Data with current layout, the export limit is 150,000 data intersections. For a table visual, each row has 1 data intersection. For a matrix visual, each row can have 1 or more data intersections, so the exported rows count can be less than 150,000. (For example, if a matrix visual has 3 data intersections per row, the maximum row count will be 150,000 / 3 = 50,000 rows.) The message "Exported data exceeded the allowed volume. Some data may have been omitted." will be added at the footer of the Excel file when the limit is hit. Consider limiting the dimensions or filter the data to avoid this scenario.

If you don't think this applies you can create a ticket to confirm that you don't have something special with your data and see if that helps.

[collinq]

Hi @Anonymous ,

There are a number of potential reasons for this.  Check out this URL:

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data#limitations-and-considerations  and, specifically look at those limitations and considerations.

I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!