Microsoft Azure Table storage is a service for storing large sets of structured, non-relational data. For more information about Microsoft Azure Table Storage service, see How to use the Table Storage Service.
To import data stored in your Microsoft Azure Table Storage using Power Query:
- In the POWER QUERY ribbon tab, click From Other Sources > From Microsoft Azure Table Storage.
- In the Microsoft Microsoft Azure
Table Storage dialog box, enter your Microsoft 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 Microsoft 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 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 tables in your Microsoft 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 Microsoft 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 Microsoft Azure Blob Storage
Import data from external data sources