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

[Imamshaik]

We’ve encountered an issue with the export data functionality for the Matrix visual in Power BI when using the "Data with Current Layout" option in combination with a filter. This issue only occurs when exporting data with more than 1,000 rows, and the report is labeled with the sensitivity label: "Confidential / Microsoft Extended". When attempting to export under these conditions, we receive the following error message:"We found a problem with some content in [filename]. Do you want us to try and recover as much as we can?" When we click "Yes", the file fails to open and the recovery attempt is unsuccessful.We suspect the issue may be related to the sensitivity label interfering with how the export handles formatting or file structure for larger data sets. Could you please help us investigate and resolve this issue?

[v-pagayam-msft]

Hi @Imamshaik ,
Can you please confirm whether you have resolved issue. If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.

[v-pagayam-msft]

Hi @Imamshaik ,
I wanted to follow up to see if you had a chance to review the previous response provided by Poojara_D12 . I hope it was helpful. If yes, please Accept that  answer so that it will be helpful to others to find it quickly.
Thank you.

[v-pagayam-msft]

Hi @Imamshaik ,
Thank you for the helpful response @Poojara_D12 !
I wanted to follow up to see if you had a chance to review the previous response provided by Poojara . I hope it was helpful. If yes, please Accept the answer so that it will be helpful to others to find it quickly.
Thank you.

Regards,
Pallavi.

[Poojara_D12 · Accepted solution]

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.