Skip to content
Knowledge Base

Missing Data in Google Sheets Report

Last updated

A Google Sheets report can be missing rows, or stop a day short after a scheduled refresh. This article covers the two most common causes.

The Report Reached Its Row Limit

A Google Sheets report is missing data or does not show enough data for a date range.

Cause

Each report loads rows up to its row limit. New reports have a 100,000-row limit by default. Reports created from a template keep a default of 1,000 rows, and existing reports keep the limit they were saved with.

Solution

Edit the report in the sidebar and check the Row limit on the Options step. You can raise it up to 1,000,000.

Yesterday's Data Is Missing After a Scheduled Refresh

Your scheduled refresh runs, but the report stops one day short. For example, a date range that ends yesterday only shows data through the day before. Refreshing the report by hand later in the day brings in the missing day.

Cause

The scheduled refresh ran before your data source's daily sync had finished collecting the previous day. This usually happens when:

  • The refresh is scheduled too soon after the data source's sync time. The sync time is when collection starts, and collection can take a while.
  • Your spreadsheet and your data source use different time zones, and a daylight saving change moved the refresh closer to the sync.
  • The data source's sync time was changed, or its hour is set before the day has ended in your platform account's time zone.

Solution

  1. In your Hub, go to Sources, open the data source's Action menu, and select Edit sync time to check its time zone and hour. Blank fields mean the default: 3 AM in the data source's time zone. Click Cancel to close without changing anything.
  2. In Google Sheets, open File > Settings > General and check the Time zone. Use the same time zone as your data source's sync time.
  3. Open the Power My Analytics sidebar (Extensions > Power My Analytics > Open sidebar), click Refresh at the bottom of the sidebar, select Schedule refresh, and set the Time at least 2 hours after the sync time. Allow longer if the sync time falls between 3 AM and 7 AM Pacific Time, or if your spreadsheet uses a different time zone than the sync time. Click Save.
  4. To fill in the missing day now, refresh the report from the sidebar.

For more detail, see Configure Data Source Sync Time and Google Sheets Refresh for the Latest Data and Google Sheets Scheduled Refresh Not Running. If the missing day still doesn't appear, submit a ticket.

Related Articles