Fabric SQL Database User defined functions

[Salvor71]

I've just started fiddling with Fabric SQL Database trying to create one of the db I use on my on-premises Sql Server and I discovered that scalar-valued and multi-statement table-valued functions are not supported. Ok, this is stated in the documentation, but will they ever be supported in the (near) future?

[Salvor71 · Accepted solution]

Hi @V-yubandi-msft,

thank you for replying.

I realized I that the documentation (CREATE FUNCTION (Azure Synapse Analytics and Microsoft Fabric) - SQL Server | Microsoft Learn) is actually referring to the SQL Analytics endpoint where I could successfully create an in-line table valued function, but of course not the other two kinds of functions. On the other end, in the SQL database itself I could create all three kinds. Perhaps the docs are a bit misleading, and are not including the new database type yet. Also I had too many windows open and didn't realize I was working on the wrong one 😊.

[V-yubandi-msft]

Hello @Salvor71 ,

Thank you for the update. If the issue is resolved, please mark it As the Accepted solution. This will help other community members who are facing a similar issue to find the solution easily.

Regards,

Yugandhar.

[V-yubandi-msft]

Hi @Salvor71 ,

Thank you for contacting the Microsoft Fabric Community. Currently, scalar-valued functions and multi-statement table-valued functions are not supported in the Fabric SQL Database, as stated in the official documentation. Microsoft has not yet announced plans to add support for these functions. However, the Fabric SQL Database is continuously evolving, with new features being added regularly.

Fabric Ideas - Microsoft Fabric Community feedback submitted here is often reviewed by the product teams and can lead to meaningful improvement.

To stay informed about the latest updates and feature releases, please refer to the official Microsoft resources.

What's New? - Microsoft Fabric | Microsoft Learn

Microsoft Fabric and Power BI release plan documentation - Microsoft Fabric | Microsoft Learn

If you have a specific use case, we can consider alternative approaches.

1. Views for reusable query logic 2. Stored procedures for handling complex logic.

While these alternatives may not completely replace scalar-valued or multi-statement table-valued functions in all scenarios, they can be effective workarounds for many use cases.

Please let us know if you require any further assistance.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.