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
When using PMA's Sheets Data Connector, your Google Sheets 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 workbook and apply functions and formulas in a second workbook, referencing data from the first workbook.
Important: These workbooks must be two separate Google Sheets documents, not two spreadsheet tabs within the same document.
- Create the first workbook. Use it only to fetch data using the Sheets Data Connector, without applying any formulas.
- Copy the URL of the Google Sheets document from the address bar.
- Create a second workbook to import the data from the first workbook and apply your formulas to the data.
- To reference the first workbook, use the IMPORTRANGE function with the URL of the workbook, the name of the sheet, and the range of cells containing the data. For example, to import the data from cells A3:B102 in Sheet1 of the first workbook at https://docs.google.com/spreadsheets/d/1-ELZ9LV6pOazr5vNldKzbcQPAPYKM0c3gFoqPF7yip7, enter the following in the appropriate cell in the second workbook:
=IMPORTRANGE(“https://docs.google.com/spreadsheets/d/1-ELZ9LV6pOazr5vNldKzbcQPAPYKM0c3gFoqPF7yip7”, “Sheet1!A3:B102”) - The first time this formula runs, it will result in an error, because Google Sheets requires permission for the second workbook to access the first workbook. Mouse over the cell and click Allow access in the popup to continue.
- The data from the first workbook will be loaded into the current workbook. You can now apply your formulas to this data.
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 Report Custom Conversions in Facebook Ads
Power My Analytics offers an easy way to include your custom conversions data in your Facebook Ads reports. Follow these steps to get started with reporting custom conversions in Looker Studio. If you're using custom conversions with your Facebook ...