Missing data while Exporting from PBI Table to Excel

[joellebassily-]

I have a PBI report, with one table that contains multiple rows. 

Everytime I try to export to Excel, the total # of distinct  line items should be 671 (every line item can be shown multiple times depending on how many associated "Resource names" each has). The export caps at 470 items and I cannot figure out what to do to export all 671 distinct items while showing the associated resource names (which brings the total number of rows to ~12,000). So we are not even close to the CAP that PBI has in the export to Excel (which to my understanding is 150,000).

Thanks

Joelle

[lbendlin · Accepted solution]

Export data from a Power BI visualization - Power BI | Microsoft Learn

• The maximum number of rows that the applications can export to an .xlsx file is 150,000. The actual number may be lower than 150,000 depending on query limits and visual types.

  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 one 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 three data intersections per row, the maximum row count is 150,000 / 3 = 50,000 rows.) The message "Exported data exceeded the allowed volume. Some data may have been omitted." is added at the footer of the Excel file when the limit is hit. To avoid this scenario, consider limiting the dimensions or filtering the data.