Hi @rkidev,
The download CSV limit is impacted by setting xpack.reporting.csv.maxSizeBytes
as discussed in this thread.
I would tread carefully on increasing the threshold as it has the potential to cause performance issues. There are some guidelines here in the documentation that should help if you want to tweak the settings. Alternatively can you try to split the download into 2?