Forum Discussion
Exporting Discrepancies from matrix visual in Power BI Service
Dear Community, When I try to export data to Excel using the eclipse in matrix visual, the exported figures are very far off from those reported in the visual. I believe the exported data have be...
v-yuta-msft
Community Support
Community SupportHi Che004,
Which mode are you using, import mode or direct query mode? There are limitations when you export data from visualizations.
If you are using direct query mode, the maximum amount of data that can be exported is 16 MB. This may result in exporting less than the maximum number of rows, especially if there are many columns, data that is difficult to compress, and other factors that increase file size and decrease number of rows exported.
To see more details about the limitation, please refer to:
https://docs.microsoft.com/en-us/power-bi/power-bi-visualization-export-data
Regards,
Jimmy Tao