Christian, with the settings in the article above, I could export over 200k+ rows with table view. Before I couldn't export past 20,000 rows. I haven't try exporting past 900k rows because my environment couldn't handle that much export that is why I said supposed. I totally agree with you, read the oracle documentations…

Thanks for the tips, appreciate it. My default username won't change...sigh. I've updated it few times now and it is still the number userid...

I had the same issue, googled and found this article. Implemented it and it works. https://www.clearpeaks.com/obiee-12c-export-to-excel-issue/ You will need to adjust your max number of rows based on how much your obiee environment can handle and consider/monitor whether it would impact your environment's performance if…