Delayed schema refresh in SQL Analytics Endpoint

[ashafaa]

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.

[v-cgao-msft]

Hi @ashafaa ,

Similar threads:

Solved: SQL Endpoint error: Failed to complete the command... - Microsoft Fabric Community

SQL Analytics Endpoint performance : r/MicrosoftFabric (reddit.com)

You can submit an idea to the product team to optimize the sync performance from Lakehouse to SQL Analytics Endpoint to keep it within a manageable timeframe.

Welcome to Microsoft Fabric Ideas

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[frithjof_v · Accepted solution]

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.