Error 'Required Field Is Missing: sourceValues' When Validating or Deploying a Change Set with a Bucket Field in Salesforce Reports

To resolve the 'Required field is missing: sourceValues' error, you need to ensure all bucket names in the affected report contain at least one value. Follow these steps:

Step 1: Identify the Report in the Change Set

Open the Change Set in your source Salesforce org and identify which report is included. Navigate to that report.

Step 2: Edit the Bucket Field

1. Open the report in Edit mode.
2. Locate the bucket field that contains an empty bucket name.
3. Add at least one value to each empty bucket.
4. Save the report.

Step 3: Re-deploy the Change Set

After saving the report with all buckets containing values, retry the Change Set validation or deployment.

Alternative: Delete and Recreate the Bucket Name Post-Deployment

If the bucket name must exist without a value in the source org, delete the empty bucket name before deploying, then recreate it in the target org after the Change Set has successfully deployed.