Thank you for this new update.

Hi Suresh, Thank you. Yes we have set both schedule refresh and direct lake enabled. We have migrated 6 datasets and all have the same configuration. Error appears only in 2 to 3 daatsets. Because every day production data needs to updated, so we have enabled the schedule refresh. Let me test for one of the dataset disable the direct lake. Thank you once again

Hi Sonia, thanks for your response. We are using pipelines to get the data from master lakehouse which is from SQL source and our bronze pipelines will get the data from master lake and transformation ( cleaning) and save the table in lakehouse_3e( first layer) and then we have one more lakehouse_da where all our silver tables are stored joining lakehouse_3e tables -- silver tables are connected to fabric semantic model and we build our power BI reports. Yesterday we could change the schedule refresh with 30 minutes of gap between each dataset. we could find no failures. we need to monitor for a while to see if it is a stable.