We have a table in the PowerBI report, which we are trying to export to excel, when we export the excel file gets downloaded successfully, but when we open it, it is giving an error as shown in the attached snapshot.
The error says We found a problem with some content in 'xxxxxxxxxxxxx.xslx'. Do you want us to try to recover as much as we can? If you trust the source of this workbook, Click Yes.
When we click on Yes to get the excel file repaired, it is opening but it is not giving any data inside it, all we can see is an empty excel sheet.
Could you please tell us how we can get this resolved.