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.
In the POWER QUERY ribbon tab, select From Azure > From Microsoft Azure Marketplace.
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.