Refreshing Data Warehouse

[gspango]

I am new to using Power BI's built in Data Warehouse. I have used Dataflows Gen1 in the past to load data into Power BI for transformations to then ultimately load it into Power BI desktop and create semantic models. 

I am trialing Fabric's Data Warehouse using the built in connection for an Oracle Database. I am pulling a subset of tables from our test invironment to do some playing with the Warehouse itself. 

I created a Test "View" that I can't seem to get rid of, and I also have an old "Table" being loaded in even though I erased the source dataflow for that. How do I rid of these old "Views" and "Tables"? I tried to refresh but there is no way to refresh, seemingly. 

I reiterate that this is a Microsoft Fabric Trial Workspace. 

[FabianSchut · Accepted solution]

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

[Anonymous · Accepted solution]

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!

[FabianSchut · Accepted solution]

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