AzureStorage.BlobContents
One blob of Azure Blob Storage, by its address, as a binary to read with Csv.Document, Parquet.Document or another reader.
Group: Files and documents. Power Query M has it too: a query that uses it is written as in Power BI.
Syntax
AzureStorage.BlobContents(url as text, optional options as nullable record) as binary| Parameter | Type | Description |
|---|---|---|
url | text | The blob's address: https://<account>.blob.core.windows.net/<container>/<blob>. |
options | nullable record optional | BlockSize, RequestSize and ConcurrentRequests are accepted; they change nothing here. |
Returns
binary. The blob's bytes, read when something uses them.
Remarks
- The sign-in is kept for the level you choose: the storage account, a container or a folder. It is Anonymous (a public container), Organizational account, Account key or Shared access signature (SAS), as Power BI Desktop offers them.
- An address that carries a shared access signature (?sv=...) is read with it.
- The rows of
AzureStorage.Blobshold the same binaries in their Content.
Examples
A CSV blob
Csv.Document(AzureStorage.BlobContents("https://norwayanalytics.blob.core.windows.net/exports/orders.csv"))Result: not shown here: it needs an Azure storage account and a sign-in.
A Parquet blob
Parquet.Document(AzureStorage.BlobContents("https://norwayanalytics.blob.core.windows.net/exports/orders.parquet"))Result: not shown here: it needs an Azure storage account and a sign-in.
Related functions
AzureStorage.Blobs, AzureStorage.DataLakeContents, Csv.Document, Parquet.Document, Web.Contents.