Skip to main content

Troubleshoot `Too many rows` in Data Studio exports

Reduce report query size to resolve the Too many rows error in 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?