Refreshing Data Warehouse

If you open the warehouse in Fabric, you can create T-SQL statements to delete tables and views. Use DROP TABLE [TABLE_NAME] and DROP VIEW [VIEW_NAME] in the query editor. Here are some screenshots too: https://community.fabric.microsoft.com/t5/Data-Warehouse/Deleting-tables-in-a-warehouse/m-p/3963166

Hi gspango 

Please follow Fabian's suggestions to delete the unwanted tables and views. 

Here's a brief explanation about the difference between dataflow Gen1 and dataflow Gen2 to help you understand why you can't delete the tables/views by erasing the source dataflow:

• Dataflow Gen1: The dataflow you used to use in Power BI is Dataflow Gen1. By default, they load data to Power BI’s managed storage. When you remove the queries in a dataflow or remove the entire dataflow, it will remove the corresponding data from the managed storage. 
• Dataflow Gen2: The dataflow in Data Warehouse is Dataflow Gen2. Dataflow Gen2 allows you to transform data into dataflow's internal/staging storage where it can be accessed using the Dataflow connector. It also allows you to specify various data destinations for your data. Using this feature, you can separate your ETL logic and destination storage. 

From your description, it seems that you have loaded the data into a warehouse. So removing the source dataflow Gen2 only removes its ETL logic, but the loaded data is still stored in the destination warehouse without being affected. So you need to use T-SQL statements to delete tables and views in the warehouse. 

Differences between Dataflow Gen1 and Dataflow Gen2 - Microsoft Fabric | Microsoft Learn

Move queries from Dataflow Gen1 to Dataflow Gen2 - Microsoft Fabric | Microsoft Learn

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!