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

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 Learn

Hope this helps. Please reach out for further assistance.

Thank you.