The Great PowerPivot FAQ - Can I use SharePoint lists as a data source?...

Title

Can I use SharePoint lists as a data source?

Answer

Yes, all SharePoint 2010 lists are now exposed as data feeds, which can be imported into PowerPivot by clicking the export as data feed button in the SharePoint UI, or entering the feed URL directly into PowerPivot using the "From Data Feed" button in the PowerPivot window.

Client/Server

Client

Topic

E - Importing Data

Purpose

Information

Answered?

Yes

Contributor

Rob Collie

Título

Posso usar as listas do SharePoint como fonte de dados?

Resposta

Sim, todas as listas do SharePoint 2010 podem ser expostas como feeds de dados. Eles podem ser importados no PowerPivot através do clique no botão "export as data feed" na interface do SharePoint ou entrando a url do feed diretamente no PowerPivot usando o botão "From Data Feed" na janela do PowerPivot.

PowerPivotPro's FAQ Site