Data export error

Hi 想要多多的赚钱​ ,

Thank you for reaching out to Microsoft Fabric Community Forum, Below are the few points which can resolve your issue. Let us know if you need any further assistance.

The error indicates that Power BI Service was unable to generate the query required for the Export Data operation. This can occur when the matrix visual contains fields or measures coming from multiple tables, or when the visual has a complex model/query structure.

Since recreating the matrix with the same measures and filters allows the export to work, this strongly suggests that the issue is specific to the original visual rather than the underlying data.

1. Verify whether the matrix contains fields/measures from multiple tables. If possible, use fields from the same dimension/fact structure.
2. Check whether any measures use complex DAX, especially measures involving SUMX, CALCULATE, TREATAS, SELECTEDVALUE, or multiple unrelated tables.
3. Remove the fields/measures from the matrix one at a time and test Export data to identify which field is causing the issue.
4. Check the matrix's Export data setting under the report/tenant settings and make sure summarized data export is allowed.
5. If the newly recreated matrix works with exactly the same fields, filters, and measures, replacing the original matrix with the recreated visual is a valid workaround. This can resolve visual-level metadata/query issues without changing the underlying model.

If the issue occurs only with the original matrix and cannot be reproduced after recreating it, there may not be a problem with the dataset itself; the original visual may have had a stale or corrupted visual/query definition. If the issue continues even with a newly created matrix, then we should investigate the specific measures, relationships, model structure, and export limitations further

Thanks