What to Do When a Report Is Loading Slowly

What to Do When a Report Is Loading Slowly

We understand how frustrating it is when you take time to build a report and it is loading very slowly or timing out. This article will help you with some troubleshooting steps you can use to get your reports loading quickly again.



Looker Studio

Use a Shorter Date Range

A longer date range means more data, which can take a longer time to load. If your report uses a very long date range, try reducing it to increase loading speed. Using the date range control, reduce the time frame and report only the time you need.



Use Fewer Live Metrics

Live metrics continuously pull data from the source. Constant refreshing can cause a report to load slowly. 
Our Schema Explorer indicates live metrics with a lightning bolt icon . You can remove these metrics from tables that do not require them.



Create a New Table

Sometimes an element of a table or chart has become corrupted. Copying and pasting the table preserves the corrupted elements. Create a new table using the same metrics and dimensions to solve this problem.


Google Sheets and Excel

When using PMA's Sheets Data Connector, your Google Sheets or Excel reports may time out or be slow to load if you are applying functions and formulas directly to the data being fetched. To avoid this, fetch the data using the Sheets Data Connector in one sheet and apply functions and formulas in a second sheet, referencing data from the first sheet.

1. Create the first spreadsheet and use it only to fetch data using the Sheets Data Connector, without applying any formulas.



2. Create a second spreadsheet that contains the formulas you want to apply to the data, and make sure these formulas reference the first spreadsheet. For example, instead of =SUM(B2:B6), use =SUM(Sheet1!B2:B6), with Sheet1 being the name of the first spreadsheet.



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

      • 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 ...
      • Some Fields in My Report Say “No Data."

        This article will help to solve the following error in Looker Studio: Cause Looker Studio reports may display "No data" when there is data missing from the data warehouse. Resolution Check the date range specified on the report. Select a date range ...
      • What Time Does My Data Refresh?

        After you create a report with PMA, your report's data will be updated automatically. This article explains how to choose the sync time for your data to refresh. When Does My Report's Data Refresh? Most connectors default to refresh every day at ...
      • Apps Script Error: This Report is Over 50MB of Compressed Data

        Error You may receive the following error message in your Looker Studio or Google Sheets report: "Apps Script error: This report is over 50MB of compressed data. Please reduce the date range and/or fields in this report." Cause Power My Analytics' ...
      • How to Create a Report in Data Explorer

        Data Explorer is a valuable tool that can be used to create reports for export to BigQuery or FTP , to test out a connection, or even to create a CSV file. This tool is available to all Power My Analytics customers and is included in the cost of your ...