How to model/ingest paths as columns?

[Anonymous]

I am ingesting the output of a .ps1; which consist of folder paths + individuals with access:

Most of paths are as above:

Path1\path2\path3\path4\path5

But I have some that are:

Path1\path2\path3\path4\path5\path6\path7

(I also have an 8th and 9th column; which are: name and access).

If I use a matrix and display columns: Path1,path2,path3,path4,path5, name, access… I get a very nice visual.

But if I use path 6 and 7 too I get a lot of blanks and the matrix doesn’t work as expected.

Is my modelling wrong? How should I ingest/display paths as columns?

[ImkeF]

Hi @Anonymous 
I have a sample file for ragged hierarchies in my blogpost here: Parent-Child Hierarchies with multiple parents in Power BI with Power Query (thebiccountant.com)
You can probably apply that to your structure as well.