Forum Discussion

stellahe102's avatar
stellahe102
Helper I
1 year ago
Solved

transient issue in directLake Semantic Model refresh

Hi,   I have a directLake semantic Model set to refresh daily at 7am, it occasionally yields this error in below. The semantic model is only set to refresh once a day at 7am, but as you can see in ...
data engineering
lakehouse
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi stellahe102,

     

    Here are the answers to your questions.

     

    1. you can check recent changes by running the sys.delta_history  function in a Fabric Notebook (Spark) or SQL query editor.

     

    2. Could you turn off the refresh that is highlighted in the screenshot below

     

    Regards,

    Vinay Pabbu

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi stellahe102,

 

Thank you for reaching out to Microsoft Fabric Community Forum.

 

This unexpected DirectLake refresh at 7 AM is likely triggered by metadata changes in the underlying Delta tables. Even if no data changes occur, modifications such as schema updates, column reordering, or changes in Delta table properties can still prompt a refresh. Microsoft Fabric detects these changes and initiates an additional refresh.

If this additional refresh is unnecessary, consider adjusting the refresh schedule or disabling automatic DirectLake refresh to prevent transient errors.

 

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!


Regards,
Vinay Pabbu