Forum Discussion
Is it possible to represent a windows file and folder structure in a report?
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
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.
9 Replies
- KNP
Super User
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."
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.
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.
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.
Thanks All, using all the examples AI gives me just doesn't work, end up with the following:
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.
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.
