Skip to main content

Troubleshoot slow Google Data Studio reports

Reduce slow loading and rate-limit errors in Google Data Studio reports that use a Funnel export.

Problem summary

Your Google Data Studio report can load slowly or fail when it requests too much data from a Funnel export.

Error message or symptoms

  • Report pages and charts take a long time to load.

  • Some charts time out or show a rate-limit error.

When does this occur

  • A page contains many charts.

  • Charts use long date ranges or many high-cardinality dimensions.

  • The report uses many blends, calculated fields or filters.

  • Time series charts request more detail than the report needs.

Root cause

Google Data Studio sends at least one query to Funnel for each chart. Complex reports require Funnel and Google Data Studio to process and transfer more data.

Solution

  1. Reduce the number of charts on each page.

  2. Remove dimensions that the report does not need.

  3. Shorten date ranges and use total-value charts when you do not need a time series.

  4. Move transformation and filtering logic from Google Data Studio to Funnel.

  5. Limit the fields and data in the Funnel export. See Export Funnel data to Google Data Studio.

  6. If the report requires highly segmented data, export to Google Data Studio through BigQuery.

Did this answer your question?