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
Syntax
Folder.Files(
path as text,
optional options as nullable record,
) as table
Description
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.
Related articles
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
Related functions
Other functions related to Folder.Files are:
2023-2024 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy