Connect to Microsoft Azure Marketplace (Power Query)

Important   This article applies to Power Query, a data analysis feature available for Excel that lets you discover, combine and refine data. You may need to enable Power Query in Excel. You can also download and install the most recent version of Power Query for Excel, which automatically enables it. Power Query technology is also built into the Power BI Designer, which is a stand-alone report authoring and data transformation tool for Power BI.

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

    Get external data from Azure
  2. If this is the first time you connect to Microsoft Azure Marketplace, you will be asked to provide your Microsoft Azure Marketplace credentials. You can either provide a Feed Key or Sign In using your Microsoft account.

After the connection succeeds, you can use the Navigator pane to browse your Microsoft Azure Marketplace subscriptions, preview data and use functions available on each service.

Applies To: Excel 2013, Excel 2010

Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language