Skip to main content
Sign In |
  Help (new window)

PowerPivotPro's FAQ Site

Go Search
  
PowerPivotPro's FAQ Site > The Great PowerPivot FAQ > How can I import public data made available via the Internet?  

The Great PowerPivot FAQ: How can I import public data made available via the Internet?

Title

 How can I import public data made available via the Internet? 

Answer
Use the Data Feed data source in PowerPivot.
 
PowerPivot v1 provides out-of-the-box support for ATOM 1.0 data feeds. All SQL Server Reporting Services (SSRS) 2008R2 reports as well as SharePoint 2010 lists are consumeable by PowerPivot via ATOM 1.0 feeds. While the aforementioned ATOM-based data sources are probably the most common you can also leverage ATOM 1.0 in PowerPivot to consume public (Internet) data feeds as well.
 
There are many public locations of ATOM 1.0 data feeds, one such example can be found at http://www.weather.gov/alerts-beta/

Client/Server

 Client 

Topic

 E - Importing Data 

Purpose

 Information 

Answered?

 Yes 

Contributor

 Derek Comingore 

Título

 Como eu posso importar dados públicos disponíveis através da internet? 

Resposta
Use a fonte de dados "Data Feed" no PowerPivot.
 
PowerPivot v1 provê suporte para feeds de dados ATOM 1.0. Todos os relatórios do SQL Server Reporting Services (SSRS) 2008 R2, bem como as listas do SharePoint 2010 são consumíveis através do PowerPivot como feed ATOM 1.0.
 
Existem muitos locais públicos de feeds de dados ATOM 1.0, por exemplo, um pode ser encontrado em http://www.weather.gov/alerts-beta/

Frage

 Wie kann ich im Internet öffentlich zugängliche Daten in PowerPivot importieren? 

Antwort
 

preRTM

  
Attachments
Created at 1/16/2010 12:00 AM  by Derek Comingore 
Last modified at 4/23/2010 1:18 PM  by Jochen Juelke