Export Summarized Data to Excel with NaN Results in Excel Warning

[mikehildner]

When exporting summarized data from a table to Excel, and the table contains a measure with a "Nan" value, opening the Excel doc gives an error warning: "We found a problem with some content in 'data.xlsx'. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes."

I have a small sample .pbix that reproduces the issue.

[v-qiuyu-msft]

Hi @mikehildner, 

Please upload your sample pbix file to your OneDrive, paste the share link here. 

Best Regards,
Qiuyun Yu

[mikehildner]

Hi Yu,

Here's the link - .pbix contains brief instructions.

https://sunhydraulics-my.sharepoint.com/:u:/p/mike_hildner/EaKicOhanVRIqZiXP82Lk2IBuRMwRN2vJ79jeiQM2...

Thanks,

Mike