Get the List of FOLDERS only in Power BI using Power Query

There are times that you need to get the list of FOLDERS and not just files. Of course folder itself (without considering files in it), doesn't contain data to be used for a report. However, sometimes, even the folder name might contain some useful information. The Get Data From Folder option in Power BI will just give you a list of files. There is a little trick that can help you to get a list of folders. Let me show you how.
Read my blog article for more information and details:
radacad.com/ge...

[@imadbabbili]

This doesn't retrieve subfolder.

[@sumit147601]

how about showing the sub folders also?

[@janfrederikbleshoy8369]

But how list subfolders also?

[@RMA_fishy]

Thank you. Very straightforward and well explained.

[@zhlen]

I am working on visualizing the number of files and the size of files under each folder. I intended to build a ragged / unbalanced hierarchy of folder directory. However, I am not successful at the moment. Any suggestion?

[@MohammadAshooryan]

very usefull. thank you for sharing. good luck.

[@khardu]

Thanks, that was helpful.

[@alvez1]

Best video ever thanks