Get data from Microsoft Azure Marketplace

Microsoft Azure Marketplace features data from a variety of sources, including demographic, environment, financial, retail and sports data. Many sources are free. You can get data feeds to use this data in a Data Model that you build in Excel and in the Power Pivot add-in.

Start from Microsoft Azure Marketplace

On first use, fill in account information and create an account ID to use when importing or exporting to Excel.

Click Data.

Under Price, click Free to list just those data sources that are free of charge.

Click the data source. For most data sources, including free ones, you will need to sign up to use it. Click the link to sign up.

On the data source page, look for Explore this Data. Most pages have a link with this name, that when clicked, opens a query window.

Run the query.

In Export to Program, choose Excel Power Pivot, and then click Download.

When prompted to open or save the document, click Open.

Click Create a New Workbook, and then click OK. Excel opens, starts the Power Pivot add-in, opens the Power Pivot window, and starts the Table Import wizard, with the data feed URL already specified.

Power Pivot may ask for an Account ID. Find the Account ID on the My Account page on Azure Marketplace.

Start from Power Pivot

In Excel, Power Pivot tab > Manage Data Model to open the Power Pivot window.

On Home > Get External Data > From Data Service > From Microsoft Azure Marketplace.

Microsoft Azure Marketplace opens on the Catalog page of the site. Select settings in the left to filter the data by type, price, category, and publisher. Browse and sign up for free or purchased datasets you can import directly into Power Pivot.