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...
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...
Further testing reveals that the Wait activity is necessary - I had two copies of the model in different workspaces, so I set my pipeline up to refresh on immediately after the script query, and the other after waiting 60 seconds, and only the second one showed fresh data this morning.