cancel
Showing results for 
Search instead for 
Did you mean: 
asymkin
Sisense Team Member
Sisense Team Member

50,000 Row Limit in Live Model export to CSV

This article gives detailed steps on how to overcome the 50,000-row limit in Live Model export to a CSV file. 
When downloading data from a Sisense Dashboard, based on a Live Model, into a CSV format, Sisense imposes a 50,000-row limit. Any more data available is simply ignored and not provided in the download. Many customers require a single download containing all required records in a single CSV file in order to process their requests.
By default, Sisense limits Live model CSV export to 50,000 rows, which is configured in the Live model > Query Settings menu, Result Limit parameter:
 
jcordell_1-1680635948131.png

 

To export more than 50K rows to CSV, Sisense admin should set LimitOfDownloadRowsForLive property to the required limit in the System Configuration menu:
  • go to Admin tab, Server & Hardware > System Management menu of the left sidebar, Configuration link
  • Click on the Sisense logo five times, go to the Query menu
  • locate LimitOfDownloadRowsForLive.value parameter and specify the required limit
  • save the changes

jcordell_2-1680636051455.png

 

When set to 0 (default), the limit is according to the query limit's setting, otherwise, the parameter value limit is used.

Sisense supports exporting up to 2B rows to CSV.
Please refer to Sisense documentation for more details regarding Sisense Live models' limits 

Solution tested with Sisense version L2023.2
In this post, we went through the steps of configuring Sisense to be able to export more than 50,000 rows Live model to a CSV file. If you tried it how, how did it go? Share in the comments! 
Rate this article:
Version history
Last update:
‎04-04-2023 12:24 PM
Updated by:
Contributors