Missing Data in Google Sheets Report

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 Options. The row limit can be increased up to 1,000,000.


    • Related Articles

    • 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: Missing Google Sheets Connector Scopes

      When building or refreshing data from a Google Sheets data source in Power My Analytics, you may encounter an error message stating "Missing Google Sheets Connector Scopes." This means the Google account you connected as your Google Sheets data ...
    • Troubleshooting Google Sheets

      Most errors that occur with Google Sheets reports can be fixed easily without the need to wait for a response from our support team. This article will help you find everything you need to troubleshoot your Google Sheets reports. Google Sheets If you ...
    • Manage and Configure Data Sources

      Power My Analytics has updated the Sources page to make it easier to manage, configure, and monitor your connected data sources. This article will explain the features of the Sources section in your PMA hub and how to use it to manage your data ...
    • How to Reconnect a Disconnected Data Source

      Sometimes a connected account can become disconnected from your Power My Analytics hub, causing errors in reports. This article will show you how to reconnect a disconnected data source in your hub and get your data moving again. What Happens When a ...