AzureStorage.DataLakeContents
One file of Azure Data Lake Storage Gen2, by its address, as a binary for a reader.
Group: Files and documents. Power Query M has it too: a query that uses it is written as in Power BI.
Syntax
AzureStorage.DataLakeContents(url as text, optional options as nullable record) as binary| Parameter | Type | Description |
|---|---|---|
url | text | The file's address: https://<account>.dfs.core.windows.net/<container>/<path>. |
options | nullable record optional | Accepted as Power Query writes it; none changes the read. |
Returns
binary. The file's bytes, read when something uses them.
Remarks
- Signed in as
AzureStorage.DataLakeis: Organizational account, Account key or Shared access signature. - The rows of
AzureStorage.DataLakecarry the same binaries in Content.
Examples
A CSV file in a data lake
Csv.Document(AzureStorage.DataLakeContents("https://norwayanalytics.dfs.core.windows.net/lake/shops.csv"))Result: not shown here: it needs an Azure Data Lake Storage account and a sign-in.
Related functions
AzureStorage.DataLake, AzureStorage.BlobContents, Csv.Document, Parquet.Document.