Apps Script Error: This Report is Over 50MB of Compressed Data

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' Looker Studio and spreadsheets data connectors use the Google Apps Script platform. This error occurs when your report's data exceeds Apps Script's 50MB compressed data limit.

This can be caused by:
  1. Using an extensive date range in your report
  2. Using a large number of fields in your report

Solutions

Follow these steps to resolve the error:
  1. Reduce the date range. Narrow the time period covered in your report, or use smaller increments (such as monthly instead of yearly).
  2. Use fewer fields. Removed unneeded or unused fields from your report, and focus only on essential metrics and dimensions.
After making adjustments, reload your report. If the error persists, further reduce the date range or field count.

Best Practices

To optimize your reporting and avoid this error in the future:
  1. Plan your reports with data limits in mind
  2. Use date range controls in Looker Studio or date range settings in the spreadsheets add-on for dynamic date selection
  3. Regularly review and clean up unused fields in your data sources

    • Related Articles

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

    • Error: Data Appears Blank in Cells in Google Sheets Report

      If your Power My Analytics data appears blank in Google Sheets but becomes visible when you click on the cells, this is likely caused by incorrect column formatting. This article will help you identify and resolve this common formatting issue. Error ...

    • Error: 'Unable to get live data for this component' in Amazon Seller Sales and Traffic by ASIN Report

      This article will help to resolve the following problem: when pulling data from the Amazon Seller Central Sales and Traffic by ASIN report into Looker Studio, Data Builder, Google Sheets, Microsoft Excel, or any other Power My Analytics reporting ...

    • Report Data in Power BI

      Power My Analytics offers a native Power BI connector that allows you to load your Data Builder datasets directly into Power BI Desktop for custom reports and dashboards. This guide walks you through connecting your PMA hub to Power BI, installing ...

    • Google Ads Error: Invalid Combination of Metrics and Dimensions Report Configuration Issue

      When working with Power My Analytics' Google Ads connector, you may encounter an error stating "Invalid Combination of Metrics and Dimensions Report Configuration Issue". This guide will help you understand the cause of this error and provide ...