Forum Discussion
FOR JSON Path in Fabric Warehouse
Hi, I have noticed that the FOR JSON statement is not supported in Fabric Synapse, and was wondering if there is any alternative to it? I am working on a Stored Procedure that will be used in ...
I have now created an idea. Please vote! https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=ca025a38-228e-ee11-a81c-6045bdb0f8f5
Similarly, FOR XML isn't supported either.
If you attempt to use it in a SQL query on the Fabric warehouse, you get this error:
Msg 15868, Level 16, State 12, Line 3
FOR XML is not supported.