Fabric storage issue

[Kr97]

Hello we have implemented the Medallion architecture in the Fabric workspace and while Transforming the data a wrong Dataflow got triggered and Generated Huge stupendous amount of  Errorneous  data. We tried to find out where the data is stored but got no luck and  we are being charged for that storage . 
So now we want to get rid of that Data without affecting any of the original data. Can any one throw some light on how to Trace and troubleshoot that data and get rid off it.

Thanks in advance .

[v-jingzhan-msft]

Hi @Kr97 

If you want to find the detailed destination information of each query, you can open that dataflow, switch to Diagram view. Then in the top right corner of each query pane, hover over the destination icon to find its details and update method. You can click the icon to edit the destination.   

Best Regards,
Jing

[frithjof_v]

Which table did the erroneous Dataflow write the data to?

Did you afterwards overwrite the erroneous data with good data? So now you cannot see the erroneous data anymore, you just see the good data?

[AndyDDC]

Hi @Kr97 what was the output destination of the Dataflow? e.g a lakehouse etc

[Kr97]

Hello @AndyDDC yes the destination is lakehouse

[AndyDDC]

If you want to see the underlying data, install Azure Storage Explorer and connect to the Fabric workspace the lakehouse resides in. You can then see how much storage is being taken up.

https://learn.microsoft.com/en-us/fabric/onelake/onelake-azure-storage-explorer

If this dataflow wrote to a lakehouse table, you should just be able to delete the table