The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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?
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