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

preview_player
Показать описание
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:
  1. RADACAD
  2. Power BI
  3. Power Query
  4. Get Data
  5. Get Data from Folder
  6. Folder
Рекомендации по теме
Quickly Make List 0:01:00

Quickly Make List Of All Files And Folders

Instantly Create Folders 0:01:15

Instantly Create Folders Directly from List in Excel | Excel Tricks

Export list of 0:00:24

Export list of files, folders including subfolders to a txt file from command line

Get the List 0:05:31

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

Get a List 0:06:28

Get a List of File Names from Folders & Sub-folders in Excel (using Power Query)

How to list 0:00:39

How to list all the sub folders to Excel Sheet

Create Multiple Folders 0:01:00

Create Multiple Folders From Excel Data

Quickly List All 0:01:38

Quickly List All Files And Sub-Directories Of A Folder Or Directory In Excel

What Is the 0:03:57

What Is the PARA Method & How to Use It with TickTick?

How To Get 0:04:48

How To Get List of all Files/Folders From A Folder In Java | Java Inspires

C# Intermediate I 0:02:11

C# Intermediate I Tutorial 10 - List Files in a Directory

Create the list 0:08:03

Create the list of Files and Sub-folders in a Folder in Excel (Macro to list File Names)

How to get 0:00:51

How to get the list of files in folder using Power Automate

Sharepoint: List All 0:01:40

Sharepoint: List All Folders, Subfolders, and Files by name and path

Python | List 0:01:45

Python | List Files in a Directory

How To Get 0:07:38

How To Get a List of All Subdirectories in the Main Directory with Python

How to get 0:03:48

How to get the complete List of all Hidden Files and Folders in any Windows Computer ?

Get a List 0:00:59

Get a List of All Files in a Directory 😍🔥#shorts

Effortlessly Get List 0:00:51

Effortlessly Get List of Files into Excel in Seconds - Excel#Shorts

Automatically create list 0:00:25

Automatically create list of all folder names in Excel | Excel Tips and tricks | #shorts

HOW TO LIST 0:04:18

HOW TO LIST FILES AND FOLDERS (DIR) IN CMD

CMD - list 0:01:12

CMD - list all files and/or folders names into a text file

Gettng a List 0:04:11

Gettng a List of Sub Directories From within a Directory using C#

Get list of 0:00:53

Get list of file names in a folder in Windows 11 [2024] #shorts

Комментарии
Автор

Thank you. Very straightforward and well explained.

RMA_fishy
Автор

how about showing the sub folders also?

sumit
Автор

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?

zhlen
Автор

very usefull.
thank you for sharing.
good luck.

MohammadAshooryan