Is it possible to represent a windows file and folder structure in a report?

[jimmytwoburgers]

Hi,

I am trying to represent a folder and file structure in a report.  I want to be able to expand and minimise the folders.  Is this possible within PowerBI?  I have been playing around with Matrix Visual and Hierarchies and can't get it right.  

The data is already in a SQL database and I can export to Excel.   There are two tables, folders and files.

Folder table:   id_object, foldername, id_parent
Files table: id_object, filename, id_parent

I idealy want to display it in a matrix looking like this (ignore the size / type - don't need those)

Any help would be apprechiated.  Thanks

[jimmytwoburgers]

Thanks All, using all the examples AI gives me just doesn't work, end up with the following:

[v-priyankata]

Hi @jimmytwoburgers 
Could you please review the pbix file below? It may be helpful. If you continue to have any issues, please feel free to reach out to the community.

Thank you for reaching out to the Microsoft Fabric Forum Community.

[v-priyankata]

Hi @jimmytwoburgers 
Hope everything’s going smoothly on your end. We haven’t heard back from you, so I wanted to check if the issue got sorted  If yes, marking the relevant solution would be awesome for others who might run into the same thing. if you have any other issues, please feel free to reach the communty.

[v-priyankata]

Hi @jimmytwoburgers 

Thank you for reaching out to the Microsoft Fabric Forum Community.

Please try below, For your reference, I’m attaching the .pbix file

• Add a column to distinguish between folders and files (e.g.,type="Folder" or "File")
• Combine both tables into a single table using Union in Power Query.
• Add Matrix to distinguish b/w Files and folders
  
  
  If this information is helpful, please “Accept as solution”  to assist other community members in resolving similar issues more efficiently.
  Thank you.

[v-priyankata]

Hi @jimmytwoburgers 

I hope the information shared was helpful to you. If your question has been answered, kindly mark the most relevant reply as the Accepted Solution. This small action can make a big difference for others who are looking for the same solution.

[v-priyankata]

Hi @jimmytwoburgers 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

[v-priyankata]

Hi @jimmytwoburgers 

Hope everything’s going smoothly on your end. We haven’t heard back from you, so I wanted to check if the issue got sorted  If yes, marking the relevant solution would be awesome for others who might run into the same thing.

[jimmytwoburgers]

Thanks for the pointers - I am still stuggling to achieve this.  I need it to have the folders at the top then when expanding list the subfolders or files if there are any.  Two problems I seem to have when trying every option either given to me by AI or solutions I have found googling.

- Hierachy / relationships:   Tried lots of different options, nothing really works. 
-  Matrix  - Always shows the ID and not the folder name / file name - I think its the relationships any ideas?

I am trying to get it like this:

Root
└── Folder1
     ├── Subfolder1
│   └── FileA
      └── Subfolder2
      └── FileB

I can manipulate the data easily enough but I have tried single tables / 2 tables with a relationship / 3 tables with a relationship etc etc.

I am using some very basic data as well to try and configure it

ID	Name	ID_Parent	Type
0	Root		Folder
1	Global Folder	0	Folder
2	01 Folder	1	Folder
3	02 Folder	1	Folder
6	01 Subfolder 1	2	Folder
7	01 Subfolder 2	2	Folder
8	02 Subfolder 1	3	Folder
100	Welcome.txt	6	Files
101	Hello.txt	6	Files
102	About.txt	8	Files
103	Config.txt	8	Files

Although my actual live data has 26 levels deep. 

Any help would be great

[KNP]

@jimmytwoburgers - there was a missing disclaimer from @DanielaOliveira's answer. Here, I'll add it...

"This answer was pasted directly from ChatGPT. ChatGPT can make mistakes. Check important info."