Forum Discussion
Semantic Model Refresh Not Reflecting Latest Lakehouse Data using data pipeline
Hi sumanthkakarla,
Gotcha, the embedding is a business reason that you cannot use directLake mode.
THe SQL endpoint in my experience needs some aggressive poking before it re-syncs. You can do this by using a script activity and selecting the top 1 row from the tables in your model, selecting from them will force the metadata sync.
You can also just refresh the models, wait 5 minutes, then refresh the models again. That is a messier solution, but should achieve the same goal.
If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.
Thnak you tayloramy , as sugested i have introduced a script activity, let see if that gives us the expected outcome.
Hi sumanthkakarla,
Hopefully that works! You might need to add a 1 or 2 minute wait after the script activity, so if it doesn't work try that. If that still doesn't work then we will go back to the drawing board and think up a new solution.
Hi tayloramy
That script activity did not work, still i see the latest date as 10/21/2025, the only option i can think of is refreshing twice. I will add semntic model activity one more time with wait activity of 5 minutes, let see if this gives me the accepted solution.