Why does my Looker Studio Report stop at more than 10,000 rows?

Kilian Müller
Kilian MüllerOwner of 1hold.de · Google PartnerUpdated
Looker StudioGoogle Certified Specialist

There is no general limit of 10,000 rows in Looker Studio: Google’s documentation names no such cap for tables or charts. If your report stops at 10,000 rows, the cut comes from the chart’s own row setting, from a connector or from the data source – and Looker Studio, since April 2026 called Data Studio again, documents its real limits per connector.

Google dates the rebrand to 16 April 2026 in its release notes. Most truncated tables we see were configured that way, and the documented limits are far higher. If you work with Search Console data, also read why you can’t filter Search Console data by landing page.

Where do the 10,000 rows really come from?

A table in Data Studio has a Number of rows section in its Setup tab with two options (table reference):

  • Pagination is on by default and splits the result into pages. Per page only sets how many rows one page shows.
  • Top N shows only the number of rows entered under Top rows. Without Group others, Google warns, the chart may not display all the data. A table someone once set to Top N with 10,000 rows stops there, silently.
  • Bar, pie and time series charts work the same way with a set number of bars, slices or series.
  • Exports allow up to 750,000 rows per chart. With pagination on, the whole table is exported whatever the rows per page; with pagination off, only the rows shown (export guide).

Which row limits does Google document?

  • Search Console: 50,000 rows per day, site and search type through the API and the Looker Studio connector (Search Central blog). One API request returns at most 25,000 rows (API reference). The Search Console interface itself exports only 1,000 table rows.
  • BigQuery: 2 million rows per chart query; beyond that, charts truncate the data and show a warning (BigQuery troubleshooting).
  • Extracted data sources: up to 100 MB and 750,000 rows; larger extracts are truncated (extract guide).
  • Pivot tables: up to 500,000 cells.
  • Google Sheets: a spreadsheet holds up to 20 million cells (Drive Help).
  • GA4: when a table exceeds GA4’s row limit, rare values are grouped into an (other) row – in reports, explorations and Data API responses alike (Analytics Help).
  • Third-party connectors set their own caps. If a partner connector feeds the chart, its documentation is the place to look for the 10,000.

How many rows does a real report need?

For 23 July to 20 October 2026 we counted the web-search rows the Search Console API returns for our own site and for an online shop we look after:

Rows a real Search Console table needs90 days, web search1hold.de: queries1,053Shop: queries11,153Shop: query × page17,40510,000: no Google limitSource: Search Console API, 23 Jul–20 Oct 2026, all rows returned

Our site needs 1,053 rows for its queries, 262 for its pages and 1,196 for query × page. The online shop needs 11,153 query rows, 898 page rows and 17,405 rows for query × page – the API returned all of them. With the date added, the shop reached 128,563 rows, yet the busiest single day had 1,925 rows, under 4 % of the 50,000-row daily cap. For a shop of this size, a query-by-page table above 10,000 rows is normal, and a table that ends at exactly 10,000 points to a setting, not to Google.

How do you show all rows – and when shouldn’t you?

  1. Select the table, open Setup → Number of rows and choose Pagination instead of Top N.
  2. If you need Top N, switch on Group others so the remainder appears as one row labelled Others. It does not work together with comparison metrics such as percent of total.
  3. Check the filters and date ranges of the chart, the page and the report – a filter cuts rows as well.
  4. For raw data, export with pagination switched on, or move large Search Console data into BigQuery with the bulk data export.

Treat a table with tens of thousands of rows as raw data, not as a report. Give viewers filter controls for page, query or campaign and keep pagination on; when someone needs every row, export it or query BigQuery directly.

Sources

Is a report of yours cutting off data? We check table settings, connectors and data sources and rebuild the report so every row is either shown or deliberately summarised. Book a free initial call or see our SEM strategy and analysis services.

Need personal advice?

Our Google-certified experts are happy to help – free and without obligation.

Book a meeting