Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

How to model/ingest paths as columns?

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

ovonel_0-1664355637667.png

 

 

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 1
ImkeF
Community Champion
Community 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.

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors
Top Kudoed Authors