---
title: "About row limits and missing data in Google Sheets queries"
slug: "about-row-limits-and-missing-data-in-google-sheets-queries"
description: "Learn how to avoid row limits and data missing in Google Sheets."
updated: 2026-01-29T07:10:13Z
published: 2026-01-29T07:10:13Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.supermetrics.com/llms.txt
> Use this file to discover all available pages before exploring further.

# About row limits and missing data in Google Sheets queries

If you're seeing partial results from your Supermetrics queries in Google Sheets, it's likely that your query's row limit is too small for the full results to appear.

To fix this, open the Supermetrics sidebar, navigate to the **Split by dimensions** dropdown, and adjust the **# of rows to fetch** setting.

For some data sources with query types, the setting for the number of rows to fetch is under **Report configuration**, and called **# of rows per item**.

If you can’t find the setting under **Split by dimensions** or **Report configuration**, it's not available for that data source.