Skip to main content

Troubleshoot `exec qps` quota errors in Google Data Studio

Resolve short-term request quota errors in Google Data Studio by reducing simultaneous requests.

Problem summary

Your Google Data Studio report cannot load Funnel data when the connected Google account sends too many requests in a short period.

Error message or symptoms

The error details show:

Community Connector Error

There was an error caused by the community connector. Please report the issue to the provider of this community connector if this issue persists.

Under Connector details, you see:

There was an error caused by this connector.

Under Debug, the message ends with:

Service invoked too many times in a short time: exec qps. Try Utilities.sleep (1000) between calls.

When does this occur

  • The report sends many requests within a short period.

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

  • Several Google Data Studio reports use the same Google account at the same time.

  • Connected Google Sheets use many custom functions.

Root cause

The connected Google account exceeded a short-term Google Apps Script request quota. Google returns this error when scripts make too many simultaneous calls.

Solution

  1. Wait a few minutes.

  2. Refresh the report.

  3. If the error continues, select Refresh fields for the data source.

  4. If the error continues, reconnect the data source.

  5. Move calculated fields and filtering logic into Funnel.

  6. Reduce the number of charts, blends and calculated fields in the report.

  7. Reduce the number of connected Google Sheets.

  8. Use another Google account for some reports.

Did this answer your question?