none
Power pivot data refresh error RRS feed

  • Question

  • Hi am using share point 2010 for power pivot and am facing these errors.Thanks in advance for resolving the issues.

    1. Power pivot refresh error for pivot workbook models.

    2.Error while accessing target application id from secure store service.

    3.Error about unable to refresh data connection in this workbook try again or contact system administrator.

    Sunday, November 13, 2016 4:25 PM

All replies

  • Hi Cool vishnu,

    Based on your description, there are several reasons which can cause this issue.

    1.Excel Services cannot connect to or load the Power Pivot data. Conditions that cause this error to occur include the following:

      Scenario 1: Service is not started.

      Scenario 2: Opening an earlier version workbook n the server. Or Excel Services is running on an application server that has the wrong version of the client libraries.

      Scenario 3: Domain controller is  is not available to validate the user identity. A domain controller is required by the Claims to Windows Token Service to authenticate the SharePoint user on each connection. More details, please review this article.

    2.The "Secure Store Service" was not configured properly and "Manage Data Refresh" was also not configured properly.

    When a SharePoint user defines a data refresh schedule, he or she must specify the user identity under which data refresh is performed.  Please configure Secure Store Service(SSS) according to the document.

    If you have any question, please feel free to ask.

    Best Regards,
    Angelia

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.


    Monday, November 14, 2016 2:28 AM
  • Hi

    Thanks for reply,

    1. Iam not facing any data refresh error when iam using sql server data base .

    2. whenever iam using excel files and text files as data source facing the error  for powerpivot Unable to refresh data for a data connection in the workbook.
    Try again or contact your system administrator. The following connections failed to refresh:

    Thanks in Advance.

    Wednesday, November 16, 2016 6:59 AM
  • Hi Cool,

    Do you enable your excel service? And please check your "Secure Store Service" congifured finely? Based on your description, it is caused by failed connection data source. Please check your set if it work fine. Thanks a lot.

    Best Regard,
    Angelia


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Friday, November 18, 2016 10:39 AM