Azure Blob Storage

Summary

Item Description
Release State General Availability
Products Power BI (Datasets)
Power BI (Dataflows)
Excel
Power Apps (Dataflows)
Dynamics 365 Customer Insights
Analysis Services
Authentication Types Supported Anonymous
Account key
Shared access signature (SAS)
Function Reference Documentation AzureStorage.BlobContents
AzureStorage.Blobs

Note

Some capabilities may be present in one product but not others due to deployment schedules and host-specific capabilities.

Prerequisites

  • An Azure subscription. Go to Get Azure free trial.

  • An Azure Blob Storage account. Follow the instructions at Create a storage account. This article assumes that you've already created an Azure Blob Storage account, and uploaded data files to it.

Note

If you are connecting to an Azure Blob Storage account from Power BI, the Azure Blob storage account must be in the same region as your Power BI account.

Capabilities supported

  • Import

Connect to Azure Blob Storage from Power Query Desktop

To connect to Azure Blob Storage:

  1. From Get Data, select the Azure category, select Azure Blob Storage, and then select Connect. More information: Where to get data

    Screenshot of the Get Data dialog box with the Azure Blob Storage option highlighted and the Connect option called out.

  2. In Azure Blob Storage, enter the account name or URL of your Azure Blob Storage account. Then select OK.

    Screenshot of the Azure Blob Storage dialog box where you enter the account name or the URL.

  3. If this is the first time you're connecting to this account, select either the Anonymous or Account key authentication method to sign into the Azure Blob Storage account. More information: Copy your account key from Azure Blob Storage

    Screenshot of the sign in dialog box for Azure Blob Storage, with the account key authentication method selected.

    For more information about using and managing authentication, go to Authentication with a data source.

    Note

    If you are signing in from Excel, you can also select the shared access signature (SAS) authentication method.

  4. Select Connect.

  5. The Navigator dialog box shows the files that you uploaded to your Azure Blob Storage account. Select the containers you want to use, and then select either Transform Data to transform the data in Power Query or Load to load the data.

    Screenshot of the Navigator open and containing the data from the Azure Blob Storage container.

Connect to Azure Blob Storage from Power Query Online

To connect to Azure Blob Storage:

  1. From Choose data source, select the Azure category, and then select Azure Blobs.

    Screenshot of the Choose data source page, with the Azure category selected, and Azure Blobs emphasized.

  2. In Connection settings, enter the account name or URL of your Azure Blob Storage account.

  3. Optionally, enter the name of the on-premises data gateway you require.

  4. Select the Authentication kind used to access your blob storage. If you've set blob storage for anonymous access, choose Anonymous. If you set blob storage to require an account key, choose Account key. More information: Copy your account key from Azure Blob Storage

    Screenshot of the Connect to data source page, with the example account name filled in, no gateway selected, and the Account key authentication filled in.

    For more information about using and managing authentication, go to Authentication with a data source.

  5. Select Next.

  6. The Navigator screen shows the files tht you uploaded to your Azure Blob Storage account. Select the containers you want to use, and then select Transform data.

    Screenshot of the Choose data page, with the data container selected, and the files from that container displayed on the right side.

Copy your account key from Azure Blob Storage

To retrieve your Azure Blob Storage account key to use while authenticating your account in Power Query:

  1. Sign in to the Azure portal.

  2. Locate your Azure Blob Storage account.

  3. In the storage account menu pane, under Security + networking, select Access keys.

    Screenshot of the example storage account in Azure, with Security + networking and Access keys emphasized.

  4. In the key1 section, locate the Key value. Select Show next to the key value.

  5. Select the Copy to clipboard icon to copy the Key value.

    Screenshot of the Access keys page, with the Key under key1 shown, and the Copy to clipboard icon emphasized.