Get data from a data feed in Power Pivot

Data feeds are XML data streams generated from an online data source and streamed to a destination document or application. You can import a data feed from a variety of data source directly into a Data Model by using the Table Import Wizard in the Power Pivot add-in. 

1. Start with an OData data feed and check whether you have permission to connect to it. You can't import an RSS feed.

2. In Power Pivot in Microsoft Excel 2013, Click Home > From Data Service > From Odata Data Feed. The Table Import wizard opens.

3. Type a descriptive name for the feed you are accessing. If you are importing multiple feeds or data sources, using descriptive names for the connection can help you remember how the connection is used.

4. Type the URL address for the data feed. You can get data feeds from Microsoft Azure Marketplace. Other sources include:

   • An XML document that contains the feed. For example, the following URL points to a public feed on the Open Government Data Initiative web site: http://ogdi.cloudapp.net/v1/dc/banklocations/

   • An .atomsvc document that specifies one or more feeds. An .atomsvc document points to a service or application that provides one or more feeds. Each feed is specified as a base query that returns the result set.

   • You can specify a URL address to an .atomsvc document that is on a web server or you can open the file from a shared or local folder on your computer.

5. Click Test Connection to make sure the feed is available. Alternatively, you can also click Advanced to confirm that the Base URL or Service Document URL contains the query or service document that provides the feed.

6. Click Next to continue with the import.

7. In the Select Tables and Views page of the wizard, in the Friendly Name field, replace Data Feed Content with a descriptive name that identifies the table that will contain this data after it is imported

8. Click Preview and Filter to review the data and change column selections. You cannot restrict the rows that are imported in the report data feed, but you can remove columns by clearing the check boxes. Click OK.

9. In the Select Tables and Views page, click Finish.

10. When all rows have been imported, click Close.