Connect to Microsoft Azure Blob Storage (Power Query)
Important This article applies to Power Query, a data analysis feature available for Excel that lets you discover, combine and refine data. You may need to enable Power Query in Excel. You can also download and install the most recent version of Power Query for Excel, which automatically enables it. Power Query technology is also built into the Power BI Designer, which is a stand-alone report authoring and data transformation tool for Power BI.
With Power Query, you can connect to Microsoft Azure just like you would connect to any other data source. Microsoft Azure Blob storage is a service for storing large amounts of unstructured data that can be accessed from anywhere in the world via HTTP or HTTPS. For more information about Microsoft Azure Blob Storage service, see How to Use Blob Storage.
To import data stored in your Microsoft Azure Blob Storage using Power Query:
In the POWER QUERY ribbon tab, select From Azure > From Microsoft Azure Blob Storage.
In the Microsoft Microsoft Azure Blob Storage dialog box, enter your Microsoft Azure storage account name, and then click OK.
If you are connecting to the Blob storage service for the first time, you will be prompted to enter and save the storage access key. In the Access Microsoft Azure Blob Storage dialog box, enter your storage access key in the Account Key box, and click Save.
Note If you need to retrieve your storage access key, browse to the Microsoft Azure Portal, select your storage account, and then click on the Manage Access Key icon on the bottom of the page. Click on the copy icon to the right of the primary key, and then paste the value in the Account Key box.
The Query Editor lists all the available containers in your Microsoft Azure Blob Storage. In the Navigator, select a container from where you want to import data, and then click Apply & Close.