Downloaded data file contains: Error: Could not sort by calculated field 'total_bla'. Limit reached

[rory]

Hi, I’m trying to download data for a dashboard and am getting an empty file containing:

Error: Could not sort by calculated field ‘total_bla’. Limit reached

The docs here:

Looker Documentation

Using Table Calculations

Create new fields by performing calculations on the results of your query.

If the number of rows in your query exceed the row limit that you’ve set, you will not be able to sort table calculations. This is because table calculations are only based on the rows that are displayed. Therefore, if you hit a row limit, the table calculation might be missing some rows that it should be sorting into your results. If you run into this issue, you can try increasing your row limit (up to 5,000 rows).

suggest to increase the row limit, but even when I increase it to the maximum of 5000, I am still getting the same error.

Any help is much appreciated, thanks!