I have a Data Table that can be fairly large (it is created dynamically based on user defined filters), i.e. several hundreds of thousands of rows. I would like to download that Data Table as Excel via the API.
Sometimes, I get the a warning like this
"The downloaded file contains only 90909 of 319117 rows because the Data Table is too large (max. 1000000 cells)."
Is this limit of 1 million cells a hard limit or just a safety precaution?