Folder.Files is a Power Query M function that retrieves a table containing information about each file found in the specified folder path and its subfolders. The function returns a table with file properties and a link to their content.
Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365
Folder.Files( path as text, optional options as nullable record, ) as table
Returns a table containing a row for each file found in the folder
path and all its subfolders. Each row contains properties of the file and a link to its content. The
options parameter is currently intended for internal use only.
Learn more about Folder.Files in the following articles:
- Import Multiple Files from a Folder with Power Query
In this post you will learn how to import files from a folder. Power Query makes it possible to import all Excel files from a folder. It works as follows… » Read more
Other functions related to Folder.Files are: