Reduce CRM Analytics Dataset Rows by Replacing with a Single-Row CSV File

This article explains how to reduce CRM Analytics dataset row usage by replacing the dataset contents with a single-row CSV file. Use this approach as a workaround when a dataset cannot be deleted due to existing references and the row limit has been reached.
Warning: This process replaces the dataset rows. To restore the original data, you must re-run the source recipe, dataflow, or the job or file upload that originally created the dataset. Salesforce is not responsible for any lost dataset data.
Follow these steps to replace dataset rows:

1. Create a CSV file with one column and one row.
2. Enter any column header.
3. Enter one row of data.
4. Save it as a CSV file.
5. Open Data Manager from the App Launcher.
6. Select Data Assets and open the dataset.
7. Click the Replace Dataset icon (shown in the Data Manager toolbar as an upload icon).
8. Select the CSV file created in Step 1 and follow the remaining prompts.
9. After the file upload, explore the dataset to verify there is only one row of data.
10. Ignore any email mentioning an error in the XMD, if received.
11. Verify dataset row usage by going to Data Manager > Usage, or Setup > Analytics > Getting Started.

Notes:

• If dataset row limits are still exceeded after this process, refer to the Help article on exceeding dataset row limits (see Additional Resources) for other ways to reduce dataset rows.
• If you still need to delete the dataset and are unable to do so, open a Salesforce case from the Help portal. Provide the dataset ID, Org ID (from Setup > Company Information), and grant login access.