Forum Discussion
pmscorca
Post Prodigy
Post ProdigyHow implementing an hierarchy without using a recursive CTE
Hi, I've noticed that the warehouse T-SQL doesn't support the recursive ctes and this is a pity! Now, how could I implement an hierarchy in T-SQL without a such useful and comfortable feature, plea...
lbendlin
Super User
Super UserDoes it have to be in T-SQL? Could you use the DAX PATH functions?
pmscorcaHi, I need to have an hierarchy at warehouse level and not at semantic model level.
However, the recursive CTEs are also useful for other purposes.
Update: I've created this idea Adding support for recursive CTEs in a warehouse ; please vote it, thanks.
v-menakakotaCommunity Support
Hi pmscorca ,
Thanks for reaching out to the Microsoft fabric community forum.
You’ve taken the right step by raising and sharing the idea to add recursive CTE support. That’s currently the best path forward, as this is a platform capability gap rather than a configuration issue. Encouraging others to vote on it will help increase visibility and priority.
Best Regards,
Community Support Team