AzureStorage.Blobs

Updated on

AzureStorage.Blobs is a Power Query M function that returns a navigational table containing a row for each container found at an account URL from an Azure storage vault. 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

Syntax

AzureStorage.Blobs(
   account as text,
   optional options as nullable record,
) as table

Description

Returns a navigational table containing a row for each container found at the account URL, account, from an Azure storage vault. Each row contains a link to the container blobs. 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.Blobs are:

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/azurestorage-blobs