Handle Parent-Child hierarchy in Direct Query


Need some help or idea on how to handle Parent-Child hierarchy but with Direct Query.
As we cannot use PATH function, any workaround on this ?
Lets say I have table like this :

I’m sorry, I want to give the data in table format, but I don’t know how.

Thanks in advance


Hi @Toni, a response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box. Also, we’ve recently launched the Enterprise DNA Forum User Experience Survey, please feel free to answer it and give your insights on how we can further improve the Support forum. Thanks!