trying to build a nth level parent child Hierarchy in Matrix table

[moumitadeb]

I am trying to build a hierarchy in matrix table using the below table data . Table has only 2 columns (parent & child) and the hierarchy can go till nth level.(exactly not sure how many levels it can be).However i am facing challenges with this methodology and I couldn't find a solution anywhere so I figured I'd start here.  

Below is part of sample table data:

Below the hierarchy tree i need to build:

Below the Hierarchy i am getting in PowerBI Desktop:

Any help would be highly appreciated! Thanks so much!

[moumitadeb]

Hi Folks,

If someone has come through this scenario, will highly appreciate your kind response

[Anonymous]

Hi, I had a similar issue not to long time ago. 
I mapped out the whole structure in Excel column by column, including a hierarchy level ID. I hope you will find a better soulution, but if not, I made that work after creating the relationship in the report.

[moumitadeb]

Thanks for your suggesstion. But this solution is not going to work for me as i have a dynamic data (where insert/update/delete happens). Also this is not going to reduce the manual effort involved here , if i try the same in excel column by column , as the data size is huge. Struggling with this issue need an urgent resolution.