Multi-statement table valued functions support in Fabric Data Warehouse and SQL analytics endpoint

[SMATIN]

Currently, I am not able to create my multi-statement TVF in Fabric Warehouse and SQL anlalytics endpoint. I would like to be able to do that w/o needing to do a code change.

[V-yubandi-msft]

Hi @SMATIN ,

At the moment, Microsoft Fabric Warehouse and SQL Analytics Endpoint don’t support multi-statement table-valued functions (TVFs). Only inline TVFs (single SELECT statement) are allowed.

If your logic needs multiple steps, you can

1. Try converting it into a view or an inline TVF

2. Or move the logic to a notebook or pipeline

Microsoft may add support in future updates, but for now, code changes are needed to work around this.
You can check the official documentation here:  CREATE FUNCTION (Azure Synapse Analytics and Microsoft Fabric) - SQL Server | Microsoft Learn

Keep an Eye on Updates: Microsoft frequently updates its services and features. Check the Fabric Data Warehouse release plan for any announcements regarding MSTVF support.

Regards,
Yugandhar.