Reset ETL

On the Reporting data warehouse page, you can reset the incremental ETL refresh to prompt a full refresh during the next ETL process. Under Refresh data, select Reset ETL. On the confirmation message that appears, select Yes.

When you reset the incremental ETL refresh, the existing data in the data warehouse is deleted immediately. And during the next ETL process, the ETL refresh includes the entire source database, not just the data that was added or modified since the previous ETL refresh. This task is useful to remove dated information from the data warehouse.

The Reset ETL task does not effect the OLAP cube.