Forum Discussion
Semantic Model connected to Lakehouse SQL Analytics endpoint not refreshing
Yeah, after a second test, this appears to be working...
So, all I've done is add a Script activity which runs a simple SELECT TOP 1 * FROM ... against one of the views in my Lakehouse SQL Endpoint, then a Wait activity that waits for 60 seconds, before the Semantic Model Refresh activity. I'm not sure if the Wait is actually necessary, but I figure it can't do any harm...
Hi AntoineW
One other point I would like to make is that data on the SQL analytics endpoint can take some time to reflect. This is due to the underlying changes not always being immediately available. What you could do is force a refresh of this as part of your daily data orchestration of getting data into your lake house, which will then allow the data to be correctly refreshed once. This analytics endpoint has been refreshed.
Here is how to do it: fabric-toolbox/samples/notebook-refresh-tables-in-sql-endpoint at main · microsoft/fabric-toolbox and a video Refresh Sql Endpoint REST API - YouTube