Windows 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 Windows Azure Blob Storage service, see How to Use Blob Storage.
To import data stored in your Windows Azure Blob Storage using Power Query:
- In the POWER QUERY ribbon tab, click From Other Sources > From Windows Azure Blob Storage.
- In the Microsoft Windows Azure Blob Storage dialog box, enter your Windows 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 Windows 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 Windows 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 Windows Azure Blob Storage. In the Navigator, select a container from where you want to import data, and then click Apply & Close.
Connect to Windows Azure Table Storage
Import data from external data sources