metricsign
Start free
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

  1. 1Step 1: Verify the Delta table path contains a `_delta_log` directory.
  2. 2Step 2: Check the Delta protocol version: `spark.sql('DESCRIBE DETAIL <table>').show()` in Databricks.
  3. 3Step 3: If using deletion vectors, disable them: `ALTER TABLE ... SET TBLPROPERTIES ('delta.enableDeletionVectors' = false);`
  4. 4Step 4: As a workaround, export the Delta table to Parquet and query via OPENROWSET.
  5. 5Step 5: Monitor Synapse release notes for updated Delta Lake feature support.

Frequently asked questions

How do I monitor for Delta Lake Read Error in Serverless SQL in my pipelines?

Connect Azure Data Factory to MetricSign — failed pipeline runs trigger incident alerts with the root cause, so your team is notified before users notice report failures.

Official documentation: https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/troubleshoot-synapse-studio

Other configuration errors