ODBC Query Export to Excel - Message was too large to process

Hi all,

I’m running a sql query through an ODBC connection and trying to export it to Excel. The query is running to completion, report is being exported fully. However, this error populates after the export when trying to run this process in debug mode.


Studio 2019.10.1
Using an Azure VM

Searching has returned no solution, although many users have reported this issue. Any ideas?