High severityconfiguration
Power BI Refresh Error:
SYNAPSE_SQL_0015
What does this error mean?
Synapse Serverless SQL cannot read a Delta Lake table — typically due to an unsupported Delta feature or transaction log issue.
Common causes
- 1Delta Lake table was written by Databricks using a Delta protocol version not yet supported by Synapse
- 2The transaction log (_delta_log) is corrupted or incomplete
- 3Delta Lake table uses deletion vectors or liquid clustering (not supported in Synapse Serverless)
- 4The Delta table path is incorrect or the folder does not contain a _delta_log directory
How to fix it
- 1Step 1: Verify the Delta table path contains a `_delta_log` directory.
- 2Step 2: Check the Delta protocol version: `spark.sql('DESCRIBE DETAIL <table>').show()` in Databricks.
- 3Step 3: If using deletion vectors, disable them: `ALTER TABLE ... SET TBLPROPERTIES ('delta.enableDeletionVectors' = false);`
- 4Step 4: As a workaround, export the Delta table to Parquet and query via OPENROWSET.
- 5Step 5: Monitor Synapse release notes for updated Delta Lake feature support.
Frequently asked questions
Official documentation: https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/troubleshoot-synapse-studio