Power BI Refresh Error:
DocumentClientException
What does this error mean?
A DocumentClientException with the message 'Request rate is large' occurs when ADF's copy activity exceeds the provisioned Request Units (RUs) on an Azure Cosmos DB container, causing the Cosmos DB service to throttle write or read operations.
Common causes
- 1The ADF copy activity throughput exceeds the RU/s provisioned on the target Cosmos DB container or database
- 2Too many parallel copy workers or a high degree of write parallelism configured in the copy activity
- 3Cosmos DB is using shared throughput at the database level and other collections are consuming the available RUs simultaneously
- 4Large document sizes or complex indexing policies increase RU consumption per write beyond expected levels
How to fix it
- 1Step 1: In the ADF copy activity settings, reduce the 'Write batch size' and 'Degree of copy parallelism' to lower the write throughput and RU consumption.
- 2Step 2: Temporarily increase the provisioned RU/s on the target Cosmos DB container or database in the Azure portal to accommodate the copy activity's peak throughput.
- 3Step 3: Consider enabling autoscale on the Cosmos DB container so it can automatically scale RUs during high-throughput copy operations without manual intervention.
- 4Step 4: Review the Cosmos DB indexing policy and exclude paths that are not needed for queries — reducing the number of indexed paths lowers RU cost per write.
- 5Step 5: Schedule large ADF copy jobs during off-peak hours when other workloads are not competing for the same provisioned RUs.