Connect to Microsoft Azure Table Storage (Power Query)

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 any other data source. 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:

  1. In the POWER QUERY ribbon tab, select From Azure > From Microsoft Azure Table Storage.

    Get external data from Azure
  2. In the Microsoft Microsoft Azure Table Storage dialog box, enter your Microsoft Azure storage account name, and then click OK.

  3. 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.

  4. 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.

  5. Expand the Content column, and select the columns that you want to be expanded, and then click OK.

  6. After the selected columns are available in the Query Editor,click Apply & Closeto import the data to the Excel sheet.

See Also

Connect to Microsoft Azure Blob Storage

Import data from external data sources

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!