Note: You must be registered in order to post a reply. To register, click here. Registration is FREE!
T O P I C R E V I E W
riceadam
Posted - 02/05/2026 : 01:18:57 Hi, We appear to be having problems with exporting reports to Excel. The export seems to fail due to certain values in the data. The report is quite large, and even after reducing the dataset, refreshing and exporting still takes a very long time. It looks like one specific column or record may be causing the Excel export to break. Sometimes the file is not generated at all, and other times the exported file is corrupted. Troubleshooting by removing columns one by one is difficult, since each removal requires adding NON_EMPTY_BEHAVIOR to every measure in order for the query to run—and there are around 30 measures in total. Is there an easier way to identify the problematic column or value? Are there any logs available that could help diagnose the issue?
1 L A T E S T R E P L I E S (Newest First)
admin
Posted - 02/05/2026 : 12:22:37 Please try to identity which row and column is producing the error by removing columns and rows.
Could it be some special character contained within the data?