locked
Power pivot Data refresh RRS feed

  • Question

  • Hi ,

    I created a power pivot in my Excel and it has SQL as datasource.

    I uploaded this excel on  my sharepoint server and created secure store service id.

    Now when i refresh the excel it throws error and i am clueless why it throws this error -

    "An error occurred during an attempt to establish a connection to the external data source. The following connections failed to refresh: PowerPivot Data "

    • Changed type Elvis Long Monday, November 12, 2012 10:18 AM question
    Friday, November 9, 2012 6:53 AM

Answers

  • Hi dpkas,

    This error occurs if you query PowerPivot data on a server that does not have PowerPivot for SharePoint installed. It also occurs if the SQL Server Analysis Services (PowerPivot) service is stopped, or if you are attempting to view PowerPivot data from an earlier version. For detail information, please look into the following article:
    http://technet.microsoft.com/en-us/library/ff487858.aspx

    Regards,


    Bin Long

    TechNet Community Support

    • Marked as answer by Elvis Long Monday, November 19, 2012 7:37 AM
    Monday, November 12, 2012 10:20 AM

All replies

  • What are the credentials on the Workbook? and is it an individual or a group Secure store ID?
    Friday, November 9, 2012 6:26 PM
  • Hi dpkas,

    This error occurs if you query PowerPivot data on a server that does not have PowerPivot for SharePoint installed. It also occurs if the SQL Server Analysis Services (PowerPivot) service is stopped, or if you are attempting to view PowerPivot data from an earlier version. For detail information, please look into the following article:
    http://technet.microsoft.com/en-us/library/ff487858.aspx

    Regards,


    Bin Long

    TechNet Community Support

    • Marked as answer by Elvis Long Monday, November 19, 2012 7:37 AM
    Monday, November 12, 2012 10:20 AM