# Missing Data in Google Sheets Report

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](https://knowledge.powermyanalytics.com/application/reports/configure-data-source-sync-time-and-google-sheets-refresh-for-the-latest-data/) and [Google Sheets Scheduled Refresh Not Running](https://knowledge.powermyanalytics.com/application/troubleshooting/google-sheets-scheduled-refresh-not-running/). If the missing day still doesn't appear, [submit a ticket](https://knowledge.powermyanalytics.com/support/submit-a-ticket/).
