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

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.

 

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.

 

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.