Forum Discussion

MG_powerbi's avatar
MG_powerbi
New Member
2 years ago

Fabric Warehouse

Hi, I have created a warehouse in fabric and used dataflow gen2 to bring in the tables, but when I later update the dataflow to add a new column to the table although it is shown in the dataflow but in the mapping step the new column is not shown and not added to the table in the destination.

As I move forward I need to constantly update tables when newly added columns.

Dataflow

2 Replies

  • rmsolfest's avatar
    rmsolfest
    Advocate II
    1 year ago

    I'm not sure if you've learned more on this, but I recently encountered issues with a fabric dataflow to a warehouse table when adding a column.  

     

    Steps resulting in a problem:

    1) Fabric: updated dataflow with new column

    2) Fabric: tried to create update destination table schema in UI (nope)

    3) SSMS: dropped or renamed destination table

    4) Fabric: tried to create update destination table schema in UI (looked successful until I ran -> resulted in error)

     

    Steps needed to take to add a column successfully:

    1) Fabric: updated dataflow with new column

    2) SSMS: add the column to the table (or rename the table and create a new one with the column)

    3) Fabric: update the dataflow with the new column

    4) Fabric: update the destination warehouse table to include the newly added column (still just replace data)

     

    So, I had to go outside of fabric and use another tool (SSMS) to make a modification to the dataflow with a destination to a fabric warehouse table.  As in your earlier post, the fabric dataflow does not update the destination warehouse table automatically, nor could I find a way to do it successfully without resorting to using a second tool.

     

    Has anyone found a way to update a fabric dataflow with a destination warehouse table while staying inside fabric (not requiring use of another tool)?