---
schema_version: "1"
id: 42a8e2da059c41f1e1f206ca8af5a88b4bb5d5f30233037ce0084e6a3c4083b8
title: Have I exceeded my dataset row limit, and what can I do about it?
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/bi_integrate_troubleshoot_dataset_limits.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_troubleshoot_dataset_limits.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: d3b942ebb6e8dec14cbe460a254052ca6bcca02e9f2d26afc1074fed22e5326a
description: All orgs have a dataset row limit. When you exceed this limit or create a recipe that can exceed this limit, you must reduce the number of dataset rows used or increase your limit.
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# Have I exceeded my dataset row limit, and what can I do about it?

All orgs have a dataset row limit. When you exceed this limit or create a recipe that can exceed this limit, you must reduce the number of dataset rows used or increase your limit.

You can receive errors and warnings about exceeding this limit when:

- Creating or updating a recipe. You can receive a warning like this.
    
    ```
    The dataflow job failed during completion. Run the dataflow again. If the job continues to fail, contact Salesforce Customer Support.
    ```
- Running dataflows or syncing data sync. You can receive an error like these.
    - ```
        Max_Data_Rows_Limit_Exceeded
        ```
    - ```
        Your org reached its dataset row limit, with [numberofrows] rows used of your allotted [#maxlimit]. You can't run recipes, dataflows, data sync, or upload files until you reduce your rows below your org's limit.
        ```

Your allocation limit depends on your licenses. To confirm your row limit, in Data Manager, go to Usage. Under Rows in All Datasets, review the number of rows used in all your datasets and the total rows allotted by your licenses. For more information, see [Einstein Discovery Capacities and Requirements](https://help.salesforce.com/s/articleView?id=sf.bi_edd_limits.htm&language=en_US).

To make more dataset rows available, try these suggestions.

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small ">
        <colgroup>
          <col style="width:20%">
          <col style="width:80%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d97411e67">Suggestion</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d97411e70">Description</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="Suggestion" class="slds-cell-wrap" style="vertical-align:top;" headers="d97411e67 ">Clean Out Unused Datasets</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d97411e70 ">
              <p>In Data Manager, review the Data Assets page. Remove obsolete, outdated,
                unused, or duplicate datasets. This screen also shows the number of rows each
                dataset generates. Use this information to identify datasets that you can optimize.
              </p>
              <p style="margin-bottom:0;">If a dataset is stored in a Private App, only the user who owns the dataset can
                remove or modify it.</p>
            </td>

          </tr>
          <tr class="">
            <td data-label="Suggestion" class="slds-cell-wrap" style="vertical-align:top;" headers="d97411e67 ">Filter Datasets</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d97411e70 ">Use <a href="https://help.salesforce.com/s/articleView?id=sf.bi_integrate_filter_transformation.htm&amp;language=en_US" target="_blank">filter transformation</a> in recipes to
              <a href="https://help.salesforce.com/s/articleView?id=sf.bi_integrate_add_objects_fields_to_replication_replication.htm&amp;language=en_US" target="_blank">remove unused rows</a> from a dataset.
              An object can filter its connected dataset to remove rows not used in the datasets
              referencing the object.
            </td>

          </tr>
          <tr class="">
            <td data-label="Suggestion" class="slds-cell-wrap" style="vertical-align:top;" headers="d97411e67 ">Modify Event Monitoring Configuration</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d97411e70 ">If your org uses the <a href="https://help.salesforce.com/s/articleView?id=sf.bi_app_admin_wave.htm&amp;language=en_US" target="_blank">Event Monitoring Event Monitoring
                Analytics app</a>, check its configuration and reduce the types of events
              captured and their data retention period. Delete the app if it’s not being
              used.</td>

          </tr>
          <tr class="">
            <td data-label="Suggestion" class="slds-cell-wrap" style="vertical-align:top;" headers="d97411e67 ">Expand the Limit</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d97411e70 ">You can upgrade your license or purchase additional data rows. Contact your
              Account Executive.</td>

          </tr>
        </tbody>
      </table>