Skip to main content

Troubleshoot `Too many rows` in Google Data Studio

Reduce report query size to resolve the Too many rows error in Google Data Studio.

Problem summary

A chart in your Google Data Studio report fails to load when its query returns too many rows.

Error message or symptoms

Too many rows, try using a shorter date range or fewer dimensions

When does this occur

  • A query uses a long date range or many dimensions.

  • A chart uses dimensions that contain many unique values.

  • A time series chart requests detailed data for a long date range.

Root cause

The query exceeds Funnel's row limit. Funnel stops the query to protect report performance.

Solution

Use one or more of these options to reduce the number of rows:

  • Shorten the report date range.

  • Remove dimensions that the chart does not need.

  • Add filters that limit the data.

  • Limit the data in the Funnel data share.

  • Replace a detailed time series chart with a chart that shows totals for the selected period.

Did this answer your question?