Community Connector Error: The data source API took longer than the 60 second Google Sheets or Looker Studio timeout.

Community Connector Error: The data source API took longer than the 60 second Google Sheets or Looker Studio timeout.

This article will address the following error:

"The Google Sheets or Looker Studio timeout was reached before the data source API responded. Reducing the date range may help avoid timeouts. For higher limits, contact us about enterprise solutions."

Cause

The API for Looker Studio and Google Sheets times out after 60 seconds. This error occurs if the connector's API takes longer than 60 seconds to respond. This is a limitation of Google's API.

Solution

  1. BigQuery and Power My Analytics' hosted MySQL do not have this limitation. You can avoid this timeout error by upgrading to an Enterprise plan and using BigQuery or MySQL.
  2. You can also try shortening the date range of your report. This can reduce the amount of data being requested and the time needed for the connector's API to respond.

Learn More about Enterprise Solutions

  1. Enterprise Plan Guide
  2. How to Export to BigQuery
  3. Power My Analytics' Data Warehouse Solution
  4. How to Use the SQL Connector


    Still having issues?
    Send us a ticket and we will get back to you.
    Submit a ticket

      • Related Articles

      • How to Connect a Google Sheets Report to Looker Studio

        In this article, we'll show you how to use Google Sheets as a data source for Looker Studio. Learn all about connecting your spreadsheet, choosing field types, and integrating your data into Looker Studio charts for visually engaging presentations. ...

      • Community Connector Error: You Must Select a Valid Config When Connecting to the Data Source

        This article will address the following error: You must select a valid config when connecting to the data-source Solution If you are seeing this error in a Looker Studio report, reconnect the data source from your report then make sure to make a ...

      • Google Sheets Data Integration Guide

        Integrate your marketing data into Google Sheets to build custom reports and dashboards. This guide will walk through how to install the Sheets add-on, create reports, edit reports, refresh data, and more. Install the Google Sheets Add-on To install ...

      • Missing Data in Google Sheets Report

        This article will assist with the following issue: A Google Sheets report is missing data or does not show enough data for a date range. Cause Power My Analytics' Google Sheets connector defaults to a 1,000 row limit. Solution Check the sidebar under ...

      • Installing the Power My Analytics Add-on for Google Sheets

        If you'd like to merge and manipulate data from popular sales and advertising platforms with Google Sheets to create insightful and automated reporting, follow the instructions below to install and launch the Power My Analytics Sheets Data Connector. ...