Forum Discussion
How to model/ingest paths as columns?
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?
1 Reply
- ImkeFCommunity Champion
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.