Connect to Microsoft Azure Table Storage (Power Query)

Use Excel's Get & Transform (Power Query) experience to 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.

On the Data tab, click Get Data > From Azure > From Azure Table Storage. If you don't see the Get Data button, click New Query > From Azure > From Microsoft Azure Table Storage.

In the Power Query ribbon tab, click From Azure > From Microsoft Azure Table Storage. Follow the additional steps below.

Power Query Import from Azure dialog

Next

  1. In the Microsoft Microsoft Azure Table Storage dialog box, enter your Microsoft Azure storage account name or URL, and then click OK.

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

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

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

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

Need more help?

You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.

See Also

Power Query is known as Get & Transform in Excel 2016

Import data from external data sources

Expand your skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×