Hello myDBR Representative,
How is it going? I am trying to do an export on a large excel with 18k rows in 40 - 50 sheets in the workbook. I understand that the excel exports need a lot of resources to work but I'm wondering if there is any another way I can milk out the potential of the export tool to get this working? The timeout has been set to 10+ mins without any xlsx being returned. And unfortunately the csv format does not work for this situation because we need separate sheets for each returned set. I have verified that the queries in the report are returning everything in under 2 mins so I'm thinking it is the excel export that is holding the process up.
PS: I just found this post talking about one large dataset export but that was a couple years ago so I'm hoping that some update has been made since then.