Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Microsoft Fabric Dataflow Gen 2 Refresh, Creates New Table in Lake House

I created a simple Dataflow Gen 2 in Microsoft Fabric.

 

 

This Dataflow Gen 2, import a table from an excel file which is located in SharePoint.

 

This works as expected and creates Table in LakeHouse.

 

 

 

I want to refresh my table in Lakehouse via this Dataflow Gen 2.

 

 

When I click refresh on Dataflow Gen 2, it creates a new table in Lakehouse.

 

 

I want my table in lakehouse refreshed, not create a new table each time I refresh Dataflow Gen 2.

 

I believe I'm doing something wrong when I setup my Dataflow Gen 2 but not sure how to fix it.

 

Thanks in advance.

 

Dataflow

3 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Thanks Gilbert, 

      This link and your advise worked. For people who will come from google in the future make sure you select a existing table as below as default comes new table.