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...
Thanks AntoineW and tayloramy, some useful suggestions there. My report developer has published a copy into the Fabric workspace where the Lakehouse resides, so we'll see if that makes any difference. If not then I'll look at refreshing the endpoint metadata.
Unfortunately the data we're ingesting is only refreshed daily, so our testing cycle is necessarily a bit slow, but at least I've got something to work with. Thanks!
Just a quick update on this... I think I've got it working just by hitting the endpoint with a simple SQL query, waiting for a bit, and then refreshing the semantic model.
I couldn't get the metadata refresh API call working, but I think all we need to do it wake it up...
I need to do a bit more testing to be certain though.
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.