How can I change default row limits (currently it's 2000)?

Hi @Timple
You would have to build your own version. The limits for 2,000 unaggregated, 10,000 aggregated and 1 million rows are currently hardcoded.

1 Like

Is there any other option other than creating own version?

@Timple Currently no, but the Enterprise Edition will likely get options to change hardcoded limits.

Thank you so much @flamber. :grinning:

Hi @flamber. Built own version.

How to change this default limit in ‘Admin Panel’. I couldn’t find any option. I’m using v0.34.3

I don’t want to use this pick limit option. Is there any other way?

@Timple Latest release is 0.34.4
You need to change the hardcoded values and build you own version.

You mean that, before building a new version, I’ve to change the default row limits. If so, Is there any other way to do after build?

@Timple Yes, change the source before building your own version. No, there’s no other way to change the limits, but the Enterprise Edition will get environment variables to change limits on multiple things - most likely from 1.36.0

Thanks for your help!

Need one more info

As you mentioned, I have modified my simple dashboard into Embedded dashboard but I couldn’t find any download option with in dashboard but I can able to download with in question.

Did I missed anything?

@Timple There’s no download button for the dashboard, but for each card on the dashboard, when using embedding.

Yeah that’s what I mean :slight_smile:

I didn’t see any download option for each card.

@Timple Then you’re likely not using Embedding, but Public Sharing or regular view of the dashboard.

Ok Let me check on this . In this below screen,
In ‘Previwe Pane’
I can see dowload option preview,

Could you please tell me what else pending?

When I open that dashboard, I couldn’t find any option like this.

@Timple How are you opening that dashboard, when it’s not showing. I think you’re missing the point of what Embedding is:

Hello @flamber, where is the setting for 1 million row limit in the source?

@turker.tunali Pretty sure this is the one:

1 Like

Currently using Metabase enterprise edition v1.36.4. Is there any way to increase the row limits?

@sanjeev Please use the support email, when using the Enterprise Edition. As of right now, no, there’s no way to configure this.

I'm evaluating Metabase for the purposes of some technical analyses within our team and we do see some use cases where it would be very useful to have more data visible.

Are there any considerations that need to be taken before preparing a custom build with limits changed? What is the rationale for this limit to exist at the level of 2000? I suspect it is because the graphing tool used by the front-end does not cope well with more data, and not because of some limitations of the back-end?

Thank you!

@zoove Everything will become slower if you raise the level. If you set it to 100k, then that will cause more load on the database and the network transfers too, besides how the user's browser will handle the many thousands of extra DOM objects.

If you have "infinite" database resource, network speed and unlimited browser memory+CPU, then you could likely set it to 1 million. But that's not the case in the real world.

It would be more interesting to figure out where you are hitting this limitation. Can you give examples?

1 Like