Use Excel's Get & Transform (Power Query) experience to connect to Microsoft Azure Blob Storage. Azure Blob storage is a service for storing large amounts of unstructured data, like images, videos, audio, and documents, which can be accessed from anywhere in the world via HTTP or HTTPS. For more information about Azure Blob Storage service, see How to Use Blob Storage.
Click the Data tab, then Get Data > From Azure > From Azure Blob Storage. If you don't see the Get Data button, then click New Query > From Azure > From Microsoft Azure Blob Storage. Follow the additional steps below.
In the Power Query ribbon tab, select From Azure > From Microsoft Azure Blob Storage. Follow the additional steps below.
In the Microsoft Azure Blob Storage dialog box, enter your Microsoft Azure storage account name or URL, 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.