Forum Discussion
Adding a column to a Fabric sematic model table
Hello,
I have the same problem using Microsoft Fabric. I added a field in my warehouse, but it's not visible in an existing (and refreshed) semantic model. I work in the Fabric Web Environnement. Did you find a way to refresh the semantic model, including the structure, without having to delete and recreate the semantic model and losing the relationship and mesures?
Thank you,
Marco
- JP_Wisco
Helper I
I've discovered that I'm now getting consistent results opening the semantic model in the Fabric web environment and then clicking the "Edit tables" option from the ribbon. This causes Fabric to fetch a fresh version of the schema. I'll just confirm my tables without adding or dropping any from my semantic model and it refreshes my semantic model view.
edit: spelling
Thank you very much for your quick response. I've already tried to do this, but the field still doesn't appear in the model. The table in question, which is in a Warehouse, is grayed out in the screen you mentioned because I have measures inside. Is this also the case for you?
Thank you,
Marco
- JP_Wisco
Have you tried clicking the refresh icon on the right side of the search bar? I was working with a similar issue yesterday and after posting the response discovered that simply opening and confirming the tables didn't always get a full refresh of the schema. I think hitting the refresh icon before confirming may have helped. My other method is hopping into a blank Power BI report, dragging a few fields from the target table onto the canvas, and then hitting the visuals refresh button. The live query from the report seems to force the semantic model to update.
