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 ...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 ...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 ...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 ...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 ...