DataMarket and Data Services are being retired and will stop accepting new orders after 12/31/2016. Existing subscriptions will be retired and cancelled starting 3/31/2017. Please reach out to your service provider for options if you want to continue service.

Using Marketplace Datasets with PowerPivot

PowerPivot works with Excel 2010 to make it simple to import and analyze data from various sources. You can import Marketplace datasets and combine them with other data.

Step 1: Download PowerPivot

You must have Excel 2010 installed prior to this step.

Click on the link below to open the PowerPivot download page. Follow the instructions on that page to download and install PowerPivot.

Download PowerPivot

Step 2: Open the Service Explorer

You must select the data to import into PowerPivot. From the Dataset Detail Page, click the link labeled Explore this Dataset to go to the Service Explorer for the dataset you previously selected.

Step 3: Construct a Query

In the Service Explorer, you can enter parameters on the left-hand side to filter the data you will import.

If you wish, click the Preview button to see what data will be imported into PowerPivot. Note that each time you preview data it will consume one transaction against your subscription.

Step 4: Import into PowerPivot

In the Service Explorer, select PowerPivot from the Select Program dropdown menu. Then click the Open button.

When prompted by your web browser, click Open to open PowerPivot. The PowerPivot window will open. If you have multiple Excel workbooks open, you will be prompted to select which workbook you would like to import your data into.

Step 5: Enter Your Account Key

The Import Data wizard will be shown. Click the Find... button to open the Marketplace Account Keys page. Copy an account key to your clipboard and paste it in the Account Key text box in the PowerPivot Import Data Wizard.