Zoho DataPrep Plan Limits Exhausted Error in Zoho Analytics Explained

Zoho DataPrep 'Plan Limits Exhausted' Error: Why Usage Figures Can Differ Between Zoho Analytics and Zoho DataPrep

If you use Zoho DataPrep from within Zoho Analytics rather than the standalone Zoho DataPrep application, you may occasionally see a pipeline fail with the message "Cannot run pipeline: You have exhausted your plan limits", even though your own calculations of your row processing entitlement suggest you should still have headroom. This article explains why that can happen and what to check.

DataPrep within Zoho Analytics is not the same product as standalone Zoho DataPrep

Zoho offers two distinct ways to access data preparation functionality. The first is the standalone Zoho DataPrep application, a full ETL tool with its own workspaces, pipelines, scheduling, and a wide connector library. The second is the DataPrep add-on that sits inside Zoho Analytics, accessed via the Prepare Data option either during import or afterwards on an existing table.

It helps to think of the Zoho Analytics version as a lighter version of DataPrep. Several transforms available in the standalone product are not available inside Zoho Analytics, including Join, Append, Pivot, Change data type, Split, and Merge. Some other transforms are only available while importing data, and are not available afterwards if you are cleaning data that is already sitting in a table.

Note: If your data preparation needs go beyond light cleansing, such as joining datasets, pivoting data, or changing column data types, the standalone Zoho DataPrep application is the correct tool to use rather than the Zoho Analytics add-on.

Row processing limits can be tracked differently for each

Zoho One includes a DataPrep entitlement calculated as a base allowance plus an addition per employee licence, up to a stated maximum. This entitlement is what appears against the standalone Zoho DataPrep application under its Current Plan and Rows processed this month figures.

However, the row processing figures shown inside Zoho Analytics, under Rows Processed for the DataPrep add-on, can be tracked as a separate counter, and may be governed by the Zoho Analytics plan (for example Premium or Enterprise processing limits) rather than the Zoho One DataPrep entitlement. This means the "Used" and "Remaining" figures you see in Zoho Analytics will not necessarily match the figures shown inside the standalone Zoho DataPrep application, even though both relate to the same underlying account.

What to check if you see this error

  1. Compare the two usage screens. Look at Rows Processed inside Zoho Analytics and Rows processed this month inside the standalone Zoho DataPrep application. If the two figures do not match, this points to two separate counters rather than a single figure being wrong.
  2. Check the Add-Ons purchased section. If your organisation has purchased an additional rows processed bolt-on, confirm it is showing correctly against the relevant plan. A missing entry here could be due to the bolt-on being applied to a different organisation or portal than the one you are viewing, a display or sync delay, or the purchase not having completed as expected.
  3. Note the negative remaining figure, if present. A negative remaining balance while your Used figure still appears below your calculated Zoho One entitlement suggests Zoho Analytics is applying a lower ceiling than the Zoho One DataPrep entitlement, rather than an error in your own calculation.
  4. Raise a case with Zoho Support. Because this involves account-specific billing and plan configuration, it is best confirmed directly with Zoho rather than assumed from the figures alone.
Need help? If you are seeing conflicting row processing figures between Zoho Analytics and Zoho DataPrep, 1 Cloud Consultants can help you investigate the discrepancy and liaise with Zoho on your behalf. Book a discovery call with 1 Cloud Consultants.