Forum Discussion

Fabricator's avatar
Fabricator
New Member
2 years ago

Adding a column to a Fabric sematic model table

When I add a new column to a table (in Fabric Lakehouse) it does not appear when I refresh the Fabric semantic model. I have to go to 'edit tables', remove the table, and then add it again, causing m...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Fabricator 

 

Adding a new column to the table of the data source is part of a schema change for the table.

 

This is explained in the documentation

 

 

Data refresh in Power BI - Power BI | Microsoft Learn

 

If you want to refresh the table schema you changed, you can refresh it in Desktop and then republish it to Service.

 

 

 

 

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Fabricator's avatar
    Fabricator
    New Member
    2 years ago

    Thanks for the reply.

     

    This is in Fabric. The semantic model was created in Fabric and not published from Desktop.

    • richwellman7's avatar
      richwellman7
      Regular Visitor
      1 year ago

      I had to open the report in Power BI desktop.

       

      The went to open model and select the table with the missing column.

      Click on the 3 dots menu on the upper right of the table

      Select edit query

      Power query will open and indicate that the model is out of sync

      Acknowledge the error message and it should import the new column.

      Click Close and Apply to exit power query.

      The semantic model should have the new column im it.

       

      At least that worked for me.

       

      Rich W