Skip to main content

Troubleshoot slow reports in Data Studio exports

Reduce slow loading and rate-limit errors in 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?