Lakehouse SQL Endpoint: OPENROWSET - Support for FORMAT = 'DELTA' when reading from ADLS data source

[mb_]

Using the OPENROWSET protocol to read from ADLS:

Simplifying file access in OPENROWSET using data sources and relative paths (Preview) | Microsoft Fa...

The blog shows reading from CSV in ADLS, is reading from Delta Table also supported?

csv:

SELECT * FROM OPENROWSET(BULK '/Files/data/2025/0 9/sales.csv', DATA_SOURCE = 'MyAdls')

delta:

SELECT * FROM OPENROWSET(BULK '/Files/data/2025/0 9/', DATA_SOURCE = 'MyAdls', FORMAT = 'DELTA')

[mb_]

Appreciate the response @v-veshwara-msft!

Creating views against Delta tables would allow us to replicate our Synapse Serverless SQL databases in Fabric, so I would consider this a valuable feature for current Synapse users looking to migrate to Fabric.

[v-veshwara-msft · Accepted solution]

Hi @mb_ ,

Thanks for posting in Microsoft Fabric Community.

At present, using OPENROWSET with FORMAT = 'DELTA' to read Delta tables from an ADLS data source is not supported in the Lakehouse SQL Endpoint. The current preview functionality supports formats like CSV, Parquet, and JSON when accessing files through OPENROWSET.

The team is continuously working to expand format support, so this may become available in future updates.

Reference: Browse File Content Before Ingestion with the OPENROWSET function - Microsoft Fabric | Microsoft Lea...

Hope this helps. Please reach out for further assistance.

Thank you.

[vrsanaidu2025]

yes, 

SELECT *
FROM OPENROWSET(
BULK '/Files/data/2025/09/',
DATA_SOURCE = 'MyAdls',
FORMAT = 'DELTA'
)