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 ,

I wanted to check in regarding your issue. Has it been resolved, or do you need any further information. Let me know if you’d like more details.

Thanks.

[V-yubandi-msft]

Hi @SMATIN ,
If you have a moment to review my response, I hope you find it helpful. If you need any further information or clarification, please let me know. I'm happy to assist.

Thank you.

[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.

[V-yubandi-msft]

Hi @SMATIN ,
Could you let us know if your issue has been resolved or if you are still experiencing difficulties? Your feedback is valuable to the community and can help others facing similar problems.

Thank You.