Note: Power Query is known as Get & Transform in Excel 2016. Information provided here applies to both. To learn more, see Get & Transform in Excel 2016.
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.