PowerPivot data source as excel RRS feed

  • Question

  • Hi,

    Is it possible to have data source for PowerPivot as excel which is stored in SharePoint document library ? I've tried from database-> From analysis services or PowerPivot and SharePoint document library path which points to my excel file in "Server or File name" box but it throws an error.

    Any idea how to accomplish ?



    Tuesday, January 10, 2012 4:40 PM


  • OK, It was pretty simple.. Select "From other sources" button on tool bar and select "Excel" .. Then provide path of the SharePoint document library and select the excel file.
    • Marked as answer by rish211 Thursday, January 12, 2012 1:16 PM
    Thursday, January 12, 2012 1:15 PM