Delayed schema refresh in SQL Analytics Endpoint

Question

I am currently working on Fabric Lakehouse and Data Pipeline. I did refresh semantic power bi models using data pipeline in Fabric, which before the process there was other activities, one of which was copy-activity and drop-create table using the notebook. But I have experienced an error like this for 3 days at the refresh dashboard stage.

Data source error: DataSource.Error: Microsoft SQL: Failed to complete the command because the underlying location does not exist. Underlying data description: table 'dbo. ......

So my table is unreadable, but when I refresh my SQL analytics endpoint manually then re- run my data pipeline to refresh semantic model again, it is successful because the schema of the table is read. Its look like the SQL analytics endpoint didn't refresh automatically. Please help.

frithjof_v · Accepted Answer

There can be sync delays between Lakehouse and SQL Analytics Endpoint:

https://www.reddit.com/r/MicrosoftFabric/comments/1ercfha/sql_analytics_endpoint_performance/

Here are some recommendations and considerations:

https://learn.microsoft.com/en-us/fabric/data-warehouse/sql-analytics-endpoint-performance

I am hoping there will come some improvements in this area.

Forum Discussion

Delayed schema refresh in SQL Analytics Endpoint

2 Replies

Related content

Delayed data refresh in SQL Analytical Endpoint

SQL Analytics Endpoint

Lakehouse SQL analytics endpoint logs

Lakehouse SQL Analytics Endpoint no longer connecting

Possible delay between Lakehouse updates and SQL endpoint in Fabric pipeline?