DataLake.Files

Updated on

DataLake.Files is a function in the Power Query M language that returns a table of files found at a specified URL from Azure Data Lake Storage Gen1. Each row of the table contains properties of the file and a link to its content.

Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365

Syntax

DataLake.Files(
   url as text,
   optional options as nullable record,
) as table

Description

Returns a table containing a row for each file found at url, from Azure Data Lake Storage Gen1. Each row contains properties of the file and a link to its content.

Other functions related to DataLake.Files are:

BI Gorilla Youtube Channel

Contribute » | Contributors: Rick de Groot