Explore a Dataset with Service Explorer

Updated: February 12, 2014

 

DataMarket Logo

The Marketplace Service Explorer provides an easy to use interface where you can interactively consume and present datasets. With Service Explorer, you can query your datasets. If the dataset supports it, you can:

  • Create custom queries.

  • Export your data to any application that consumes OData.

  • Embed your data in an application or presentation.

  • Share the data with others.

Before you proceed, make sure that you have:

  • A valid Windows Live ID or OrgID.
    If you need a Live ID go to the Windows Live home page and sign-up for a Live ID.

  • A valid Marketplace account. If you do not have a Marketplace account, go to the topic Create Your Marketplace Account and follow the instructions there.

  • A subscription to a dataset of interest. If you have not subscribed to a dataset, go to the topic Subscribe to a Data Offer and follow the instructions there.

When you click Explore this Dataset, Service Explorer launches in a separate window or tab with one of these two results.

  1. The dataset has no required parameters (it may or may not have optional parameters).

    Service Explorer executes a parameterless query and returns the first 100 rows of the dataset.

  2. The dataset has one or more required parameters (it may also have optional parameters).

    No query is executed until you:

    1. Fill in data values for all required parameters and

    2. Click Run Query.

 

Link Description

Query a Dataset

Interactively query a dataset for the data you need. Create custom queries on datasets that support this feature.

Get the Query URL

Get the XML feed URL for this query.

Download from the Marketplace to a file

Export your query to Excel or a CSV file.

Download from the Marketplace to PowerPivot

Export your query to Excel PowerPivot.

Show: