Windows Azure Table storage is a service for storing large sets of structured, non-relational data. For more information about Windows Azure Table Storage service, see How to use the Table Storage Service.
To import data stored in your Windows Azure Table Storage using Power Query:
- In the POWER QUERY ribbon tab, click From Other Sources > From Windows Azure Table Storage.
- In the Microsoft Windows Azure Table Storage dialog box, enter your Windows Azure storage account name, and then click OK.
- If you are connecting to the Table storage service for the first time, you will be prompted to enter and save the storage access key. In the Access Windows Azure Table 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 tables in your Windows Azure Table Storage in the Navigator. Click a table in the Navigator from where you want to import data. You will see the predefined columns for the selected Windows Azure table: PartitionKey, RowKey, Timestamp, and Content.
- Expand the Content column, and select the columns that you want to be expanded, and then click OK.
- After the selected columns are available in the Query Editor, click Apply & Close to import the data to the Excel sheet.
Connect to Windows Azure Blob Storage
Import data from external data sources