Issue with "Export Data with Current Layout" for Matrix Visual in Power BI with Sensitivity Label

Hi Imamshaik 

The issue you're encountering with the "Export data with current layout" functionality in Power BI's Matrix visual appears to be specifically tied to the interaction between large data exports (over 1,000 rows) and the applied sensitivity label, "Confidential / Microsoft Extended." While exporting smaller datasets or unlabeled reports may work as expected, the sensitivity label seems to be interfering with the export process, possibly altering how metadata or file formatting is applied during the generation of the Excel file. This results in a corrupted file that triggers the error: “We found a problem with some content in \[filename]...” and fails to recover upon opening. This behavior suggests that the sensitivity label might be enforcing encryption or compliance settings that conflict with how the layout or formatting is preserved in the exported Excel structure for larger datasets. To resolve this, it is recommended to test removing the label temporarily and exporting again to confirm if the label is the root cause. If confirmed, Microsoft Purview settings related to sensitivity labels and their effect on Office file exports from Power BI should be reviewed. Additionally, ensuring that both Power BI and Microsoft 365 sensitivity label handling are updated and properly configured can help mitigate such compatibility issues. Engaging with Microsoft Support may also be necessary if this appears to be a product-level bug or undocumented limitation.