In this article we list the most common errors that our users report seeing when using our Data Studio Connector. We will do our best to explain what they mean and our suggestions for how to avoid them.

Before you start applying the suggestions below make sure you try the basics; refresh data, refresh fields and reconnect the data source. Instructions for how to do this can be found in the article Google Data Studio troubleshooting steps.

A few words on quota limits

Funnel and Google, (like any service provider with a lot of traffic) implements restrictions on how often a service can be used within certain time frames by the same entity. This is called quota limits. A user that is causing an unreasonable large load on a service risk degrading the performance for everyone else. Quota limits filter out traffic that is using the service beyond what is considered fair usage.

Google have a quota limit per Google user and day. This quota is shared between services like Data Studio, Google Sheets and Google Calendar. You can read more about these limits in the Google Apps Script documentation.

Funnel use a quota limit per Funnel Account, and it's shared across many of our features like the Data Explore, the Data Studio Connector and Data Warehouse Shares.

Most common errors in Data Studio

"Service invoked too many times in a short time: exec qps"

What happened?

You've hit a Google quota limit with too many requests in a short time. From Google's documentation; "This indicates that the script called the given service too many times in a short period".

The error message can happen if the same Google user is doing heavy calculations either in Data Studio (blends, custom fields, filters) and/or using Google Sheets with many custom functions as a data source in the Data Studio Report.


How do I avoid it?

  • Move transformation and filtering logic into Funnel (eg. custom fields)

  • Reduce complexity in the report (eg. number of charts per page, blends, custom fields)

  • If you have Google Sheets connected to the report, try and reduce the number and complexity

  • If you're using a shared Google account for many Data Studio reports and Sheets, try to split it up by connecting to Funnel with a different Google user


"Service invoked too many times for one day: urlfetch"

What happened?

You hit your daily Google quota limit. From Google's documentation: "This indicates that the script exceeded the total allowable execution time for one day. It most commonly occurs for scripts that run on a trigger, which have a lower daily limit than scripts executed manually". Specifically, it means that the Google user have had more than 20 000 data requests per day across the different Google Services.

How do I avoid it?

  • Reduce the complexity and amount of Google Services your Google user is using

  • Use a different Google user for the Data Studio report

  • User a different Google users for the data sources in the Data Studio report


"Distributed query rate limit per minute exceeded"

What happened?

You hit a Funnel Account quota limit. The amount of work required to satisfy all the queries that are being made from a single Account in a 60 second period is higher than our limit, some of the requests are being throttled.

How do I avoid it?

  • Wait a minute and try again, the rate limit is within a 60 second period

  • In the article Why is my Google Data Studio report so slow you will find suggestions on what steps to take to reduce the amount of work required by the report, for instance

    • Reduce the complexity of your report (eg. number of charts per page, number of fields per chart)

    • Reduce the volume of data that Data Studio needs to handle by applying filters to your Data Studio Data Share

  • Time your report - try to avoid loading your report during peak times when your Funnel Account might be doing a lot of other requests

  • Make sure you're within the limits of Funnel's fair usage


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

What happened?

You hit a Funnel quota limit. The query would result in too many rows and was therefore aborted, this is done for performance reasons, and to avoid sending huge or incomplete responses.

How do I avoid it?

  • In the article Why is my Google Data Studio report so slow you will find suggestions on what steps to take to reduce the amount of work required by the report, for instance

    • Reduce the complexity of your report (eg. number of charts per page, number of fields per chart)

    • Reduce the volume of data that Data Studio needs to handle by applying filters to your Data Studio Data Share

  • Make sure you're within the limits of Funnel's fair usage


"Missing or invalid date range"

What happened?

We believe this to be a Data Studio bug and have reported this in Google's issue tracker.

How do I avoid it?

Some users have reported success by trying the following:

  • Change date range in Data Studio

  • Refresh fields

  • Reconnect your data source


System Error

What happened?

This error message points to an error within Google Data Studio. The request never reached Funnel so we don't know any more details than what is shown here.

How do I avoid it?

Some users have reported success by tinkering with the following:


Seeing other errors?

Please reach out via the in-app support chat or send an email to support@funnel.io. For us to give you the best possible help we refer you to the article How to report a problem. We'll do our best to help and will update this article with new common errors and how to avoid them as we learn more.

Did this answer your question?