Lakehouse and semantic model issues

[Nikhil234]

I have a table I have updated in my lakehouse to add 2 more fields. I have queried this in the SQL analytics endpoint and my table looks refreshed.

When I tried to update the semantic model where this table is used by clicking edit tables, refresh source data and confirming, the semantic model won’t add the new fields.

I tried making a new model and updating the default semantic model of the warehouse but the new fields in my table just won’t go through.

Is there some sync issue going on? I have tried all the routes I know but I can’t find the problem.

Similarly, I made a new table via a notebook and wrote this to the lakehouse and I can see the table in the lakehouse but not in the SQL endpoint which makes me think I do have sync issues but I’m unsure how to resolve this or if that even is my issue.

Any help would be appreciated.

[Anonymous]

Hi,@Nikhil234 .I am glad to help you.
According to your description, you are experiencing a problem with the semantic model not updating correctly in Lakehouse.
I hope the following suggestions will help you
1. Try clearing your browser's cache, your previous authentication details may have expired, please try logging in again to ensure you see the latest data model.
2. Manually click the refresh button and check if you have the correct access rights to the data source and update your credentials (although this is very unlikely, it should be taken into account).
3. Check that the ability to synchronise the default model is turned on.
There are other users with similar issues who have said:
Turn on Sync Default Model. The model will update when you add more rows of data to the table Or create a new custom semantic model using the desired table. It will automatically update
URL:
Solved: Re: Semantic Model not properly refreshing - Microsoft Fabric Community
Default Power BI semantic models - Microsoft Fabric | Microsoft Learn

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Nikhil234]

I have tried all listed methods and my new feilds still wont update into the sementic model. I hav e checked spark limits but all seems fine and capacity has not throttled. Im not sure what else i can do. 

[Anonymous]

Hi,@Nikhil234 .Thank you for your reply.

This is indeed very strange. Can you please make sure that the relevant default semantic model update option is turned on.
If you really can't find the problem at the moment
You can create a support ticket for free and a dedicated Microsoft engineer will come and fix the issue for you.
It would be great if you could continue to share this issue once you know the root cause or solution to help others who are experiencing similar issues.

The Link of Power BI Support:

Microsoft Fabric Support and Status | Microsoft Fabric

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian

[Nikhil234 · Accepted solution]

After opening a support ticket i found the issue was caused by the direct lake connection failing to refresh due to a different table. Fixing the error and completing that refresh resolved the propblem.