Forum Discussion
Delta Lake Refresh Issue
Hi fazithzakirll ,
Since the other three reports are working correctly with the same setup, it seems the issue is specific to this semantic model.
The behavior you mentioned refresh time updating but data remaining unchanged typically indicates that the model is displaying cached data and not retrieving the latest information from the Lakehouse until a full model refresh occurs.
As you’ve confirmed it’s connected directly to the Lakehouse and not the SQL endpoint, here are a few things to check.
1. Compare this model to the others for differences, such as calculated columns, complex measures, or larger tables.
2. Because this model uses a calendar table in Import mode, you might try recreating or temporarily removing it to see if Refresh visuals starts updating the data.
3. If possible, make a small test semantic model using the same tables to see if it updates as expected. If the test model works, the issue is likely within this specific model.
These steps should help determine if it’s a model level issue rather than a Direct Lake problem.
Thank You.
Hi fazithzakirll,
Since 3 reports work under the same setup, most probably the issue lies within that semantic model. Additionally, refresh timestamp updates but the data does not, it suggests the model is not re-reading the latest Lakehouse data.
Could you confirm whether the semantic model is connected to the SQL Endpoint (check in settings, if model is showing DirectQuery or referencing SQL Endpoint instead of Direct Lake or Lakehouse)? It is a known observation that the SQL Endpoint can lag behind Delta commits and takes longer to sync. If yes, you should switch to Lakehouse, or give a long delay between tables update and report refresh.
Please share whatever works for you eventually, so that it helps us all in such scenarios.
The Semantic Models are all connected direclty to the Lakehouse. I am looking into other Solutions
Hi fazithzakirll ,
Since the other three reports are working correctly with the same setup, it seems the issue is specific to this semantic model.
The behavior you mentioned refresh time updating but data remaining unchanged typically indicates that the model is displaying cached data and not retrieving the latest information from the Lakehouse until a full model refresh occurs.
As you’ve confirmed it’s connected directly to the Lakehouse and not the SQL endpoint, here are a few things to check.
1. Compare this model to the others for differences, such as calculated columns, complex measures, or larger tables.
2. Because this model uses a calendar table in Import mode, you might try recreating or temporarily removing it to see if Refresh visuals starts updating the data.
3. If possible, make a small test semantic model using the same tables to see if it updates as expected. If the test model works, the issue is likely within this specific model.
These steps should help determine if it’s a model level issue rather than a Direct Lake problem.
Thank You.