---
schema_version: "1"
id: 9c91955f99d206c2440b57f73d59052c91d83ebc8d7eda24b466d816b5fa0240
title: Limit the Size of Your Query Results
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/bi_explorer_limit_query_size.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_explorer_limit_query_size.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 7524432f883bc699e42aaa33981f94f70e50014441209fb687f3402f6c542de2
description: Interested in reviewing just the top 10 accounts in your product pipeline—without excessive scrolling? To fast-track to meaningful insights and for improved performance on your dashboards, you can limit the size of query results in a lens.
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# Limit the Size of Your Query Results

Interested in reviewing just the top 10 accounts in your product pipeline—without excessive scrolling? To fast-track to meaningful insights and for improved performance on your dashboards, you can limit the size of query results in a lens.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition"><colgroup><col></colgroup><tbody><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in Salesforce Classic and Lightning Experience.</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available with CRM Analytics, which is available for an extra cost in <strong>Enterprise</strong>, <strong>Performance</strong>, and <strong>Unlimited</strong> Editions. Also available in <strong>Developer</strong> Edition.</td></tr></tbody></table>

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small permission">
        <colgroup>
          <col style="width:50%">
          <col style="width:50%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="colgroup" class="slds-cell-wrap" colspan="2" style="text-align:center;vertical-align:top;" id="d184668e47">User Permissions Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d184668e47 ">&nbsp;</td>
            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d184668e47 ">Use CRM Analytics</td>
          </tr>
        </tbody>
      </table>

1. To set the limit for your query, click the **Edit** link.
    
    ![Adding a query limit.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_explorer_limit_query_size.png)
2. Enter the size of the query result and click **Apply**.

If you edit your query in SAQL, you also need to set the query limit in SAQL.

![Tip](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/images/icon_tip.png)

Tip For a smoother scrolling experience, we recommend using the query result limit along with a chart’s auto-fit feature.