Forum Discussion

cbhoffm1's avatar
cbhoffm1
Advocate I
7 years ago
Solved

Excel Export File from a Table is Corrupt

When I am exporting data from a published report in my workspace I am getting an error message upon opening the file:                                                ...
Need Help
  • cbhoffm1's avatar
    cbhoffm1
    7 years ago

    I did some more testing on this and identified it is one record in particular that is causing the issue.  I'm not sure if it's the <blank> value in one column or the resulting Divide by 0 in another but I would not think this is enough to corrupt the workbook.  I'll let you know what I find.

  • cbhoffm1's avatar
    cbhoffm1
    7 years ago

    Upon further testing, the issue was the Divide by 0 error.  If there are any errors in the data the Excel file will throw the corrupt error instead of just treating those errors as text.  Using the replace errors function in Power Query resolved the issue and the Excel export is fine now.

cbhoffm1's avatar
cbhoffm1
Advocate I
7 years ago

 

Hi Jimmy,

 

I am using Office 365 to open the file.  When I tried excel online, I am getting the below error message.  When I click Yes, I get the same 2 messages as in my original post.

 

 

Thanks,
Chris

 

v-yuta-msft's avatar
v-yuta-msft
Community Support
7 years ago

Hi cbhoffm1,

 

This issue seems more related to O365, I would recommend you to post your issue to O365 forum.

 

Regards,

Jimmy Tao