Home > PowerPivot, Whitepaper > SharePoint List Data Source in PowerPivot

SharePoint List Data Source in PowerPivot


One of the many features of Microsoft SQL Server PowerPivot is the range of data sources that can be used to import data. Anything, from Microsoft SQL Server relational databases, Oracle databases, and Microsoft Access databases, to text documents, can be used as data sources in PowerPivot. In this paper, I explain one of the new and upcoming data sources that people are excited about – SharePoint list data in the form of Atom feeds. This white paper goes on to explain the different ways you can import SharePoint list data into PowerPivot, what types of lists are supported, various components that need to be installed to use this feature, and where to get those components.

Thanks for reading.
Advertisements
  1. Erich von Maurnböck
    May 3, 2012 at 1:40 am

    Hello,
    I’ve tried to install the ADO.NET runtime, but got an error, that said that “this update is not for your computer”. I’ve W2008R2 and tried all 3 possible updates – in german and english. No success. What can I try else?
    Thank you for any suggestions!
    Regards,
    Erich

    • May 3, 2012 at 8:37 am

      I recommend you to read the minimum requirements page for this component. Because, nowadays installation packages are assigned to only a specific environment.

  2. Erich von Maurnböck
    June 14, 2012 at 12:51 am

    Thank you, I will check that!

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: