Forum Discussion
Failed to complete the command because the underlying location does not exist LakehouseSQL Endpoint
Hello Anonymous
The SQL Endpoint’s metadata (table/file references) becomes temporarily out of sync with the actual Delta tables in the Lakehouse. This causes queries to reference outdated file paths (e.g., GUID-based Parquet files that no longer exist). The error code `24596` explicitly indicates this mismatch
This issue was discussed many times in the forum. Although it is never mentioned in known issues in Fabric docs
try Manually trigger a metadata refresh on the Lakehouse via Fabric’s UI to force the SQL Endpoint to sync
Right-click Lakehouse → Refresh
Modify your pipeline to include a retry loop with a 30–60-second wait between attempts
workarounds like forced refreshes and retries often resolve it. For critical systems, consider using Delta Lake directly
if this is helpful please accept the answer
running the same query in a %%sql cell in a notebook shows me the data, just not through the sql endpoint
- nilendraFabric
Super User
`%%sql` bypasses the SQL Endpoint and runs SparkSQL directly against the Lakehouse’s Delta tables
Spark reads Delta transaction logs directly from `/tables`, avoiding SQL Endpoint sync delaysFor now if you want to use sql. Go with this approach.
if this issue persists raise a support ticket