Limit rows in embedded requests

In my use case I use Metabase to export reports with around 300.000 rows. It's fairly fast to run the question because the web UI limits the results in 2k rows but when exporting it exports all rows.

The problem I'm having is when I embed this question. It seems that Metabase tries to return all the row at once and because of that the browser tab freezes. Is there a way of limiting rows in the embedded web UI but keeping the full results in the export?

Thank you!

Hi @seocam
Post "Diagnostic Info" from Admin > Troubleshooting.
I cannot reproduce on the latest 0.42.2 release.
Try looking at your browser requests to see what is being downloaded. I think something else is going on. Is this a table or visualization, try changing to a table.

I'm almost sure that all data is coming, because it's 312 MB of data.

Screenshot%20from%202022-03-10%2009-51-37

Maybe it's a problem in the /api/preview_embed/card/ and not in the actual embedded? I'll test to see if the real embedding behaves in a nicer way.

@seocam Okay, so it's only in the preview, I've created an issue for it:
https://github.com/metabase/metabase/issues/20938 - upvote by clicking :+1: on the first post