Scalar User-defined functions (UDFs)

Data Warehouse · General availability · Planned

Data Warehouse General availability Planned
Last Modified: May 07, 2026 Release Date: September 30, 2026

Description

We're expanding scalar user-defined functions with new capabilities, including INLINE = AUTO, improved error messaging, support for special built-in functions, and CONTINUE/BREAK statements in **computation**-based UDFs.

📰 Related Blog Article

Inline Scalar user-defined functions (UDFs) in Microsoft Fabric Warehouse (Preview)
🔗 blog.fabric.microsoft.com

Change History

  1. 2026-04-23
    Release Date 2026-06-30 -> 2026-09-30 Feature Description We're expanding the capabilities of scalar user-defined functions. This update unlocks new scenarios for expression-based UDFs including support for while loops multiple return statements and complex control flows. Additionally we've improved error messaging to make debugging easier and development more intuitive. -> We're expanding scalar user-defined functions with new capabilities including INLINE = AUTO improved error messaging support for special built-in functions and CONTINUE/BREAK statements in **computation**-based UDFs.
  2. 2025-10-16
    Roadmap Item Added
← Back to Roadmap 👁️ Watch this Feature View API JSON Workload: Data Warehouse