Updated on

AzureStorage.DataLakeContents is a Power Query M function that returns the content of a file at a specified URL from an Azure Data Lake Storage filesystem. It allows optional parameters to control settings, such as block size, request size, and concurrent requests.

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


   url as text,
   optional options as nullable record,
) as binary


Returns the content of the file at the URL, url, from an Azure Data Lake Storage filesystem. options may be specified to control the following options:

  • BlockSize : The number of bytes to read before waiting on the data consumer. The default value is 4 MB.
  • RequestSize : The number of bytes to try to read in a single HTTP request to the server. The default value is 4 MB.
  • ConcurrentRequests : The ConcurrentRequests option supports faster download of data by specifying the number of requests to be made in parallel, at the cost of memory utilization. The memory required is (ConcurrentRequest * RequestSize). The default value is 16.

Other functions related to AzureStorage.DataLakeContents are:

BI Gorilla Blog

Contribute » | Contributors: Rick de Groot
Microsoft documentation: