Semantic model doesn't update new columns in table

[egons11]

Hi, I am experiencing an issue where if I create a semantic model on top of a lakehouse with a direct lake connection. When I choose all tables in the lake, add them to the model and create it, then when I add extra columns in the lakehouse table, the semantic model doesn't reflect the new columns, even when refreshed. When I try to create a new model, then I guess it checks the schema again and sees the new columns. 

Has anybody else had this issue?

[frithjof_v · Accepted solution]

Hi @egons11 ,

Hopefully this video solves your issue:

https://youtu.be/2RuoHpNZbc4?si=A0xbDc8vrZWr-w1J

[egons11]

This for sure does solve it. Kudos, you were more helpful than MS staff, thanks a lot.

[v-cboorla-msft]

Hi @egons11 

Thanks for using Microsoft Fabric Community.

This is a known issue, when using OneLake integration for semantic models, you can export the data in a semantic model to OneLake. Data in the Semantic Model artifact in OneLake might be out of date, in comparison to the Semantic Model data. If you didn't previously export the semantic model, you don't see the data in OneLake. If you previously exported the semantic model and then added a calculated column or a calculated table column in an error state, you see an older version of the semantic model data in OneLake. The export doesn't happen and the updated data doesn't get exported to OneLake.

For reference please refer : Known issue - Semantic model export to OneLake fails for calculated columns in error state - Microso...

I hope this information helps. Please do let us know if you have any further queries.

Thank you.

[v-cboorla-msft]

Hi @egons11 

We haven’t heard from you on the last response and was just checking back to see if your query got answered. Otherwise, will respond back with the more details and we will try to help.

Thanks.

[v-cboorla-msft]

Hi @egons11 

We haven’t heard from you on the last response and was just checking back to see if your query got answered. Otherwise, will respond back with the more details and we will try to help.

Thank you.