If you retrieve data by including variables in the query, the number will be limited to 2000.
If you download in Excel or CSV, you can download all the data of over 2000 items.
It is currently October 2023, but is it possible to change the limit on the number of displayed items in the free version of metabase?
Is it still only available for custom builds?
It's coming soon, we need this for many of our customers
Is this Blizzard Soon or a regular person's soon?
Trying to create time-based graphs is pointless with a 2000 line limit. It would seem more useful to limit the size of data not the amount of lines as that is what will affect the browser the most. If I have 1000 columns of maxchar data, 2000 lines is still gonna drag the browser to its knees. 10000 lines of 2 columns of numeric data won't.
Check the latest version, it’s already there
Version number or location of this setting?
Hello,
It is kind a bit if a necro but this post is the latest related about this limit and I have found the fix.
If you are using the java jar version, simply change these two environment variables :
MB_AGGREGATED_QUERY_ROW_LIMIT=20000
MB_UNAGGREGATED_QUERY_ROW_LIMIT=10000
You can either set them with export or if you are using metabase as a service, place these exact two lines in /etc/default/metabase then do sudo systemctl daemon-reload then restart the metabase service.
this has been added in recent versions, that's why you can change it now