none
Powerpivot for sharepoint error: Unable to refresh data for a data connection in the workbook

    Domanda

  • Hello,

     I have three errors when i try to use a simple powerpivot workbook published in sharepoint: (nothing on google has help me..)

    1-Unable to refresh data for a data connection in the workbook.
    Try again or contact your system administrator. The following connections failed to refresh:
    PowerPivot Data

    2-The embedded PowerPivot data in the workbook cannot be loaded due to a version mismatch

    3-01/21/2012 17:26:47.08  w3wp.exe (0x1950)                        0x0AD0 Excel Services Application     Excel Calculation Services     bccc Medium   Session.HandleTrimmedWorkbookReloading: userOperation ApplySlicerSelectionOperation requires BaseWorkbook: "http://crm2011:2020/Marketing%20Reports/test2_excel32bits.xlsx" [0x409] [Saturday, 21 January 2012 09:40:18] [BaseWB ID: 2] to be untrimmed if it is currently trimmed. The workbook is currently NOT trimmed. fb614a65-e398-4b97-a98d-fb7b23eab39f
    01/21/2012 17:26:47.08  w3wp.exe (0x1950)                        0x0AD0 Excel Services Application     Excel Calculation Services     f1va Medium   CWorkbookWrapper::CWorkbookWrapper: Created with ID=4 fb614a65-e398-4b97-a98d-fb7b23eab39f
    01/21/2012 17:26:47.09  w3wp.exe (0x1950)                        0x0AD0 Excel Services Application     Excel Calculation Services     eq3r Medium   ConnectionRequest.ConnectionRequest: New connection request. SessionId=1.V21.4PI+fCwIq52LH++nOoMzs90.5.en-US5.en-US73.-0060#0000-10-00-05T03:00:00:0000#+0000#0000-03-00-05T02:00:00:0000#-006036.bfceb31b-7122-46ca-9e2a-ae52cefcfcaf1.N, WorkbookVersion=ConnectionInfo.WorkbookVersion: Uri=http://crm2011:2020/Marketing Reports/test2_excel32bits.xlsx, Version=Saturday, 21 January 2012 09:40:18 fb614a65-e398-4b97-a98d-fb7b23eab39f
    01/21/2012 17:26:47.12  w3wp.exe (0x1950)                        0x0AD0 Excel Services Application     Excel Calculation Services     aysl Medium   Succeeded to initialize a chart. fb614a65-e398-4b97-a98d-fb7b23eab39f
    01/21/2012 17:26:47.12  w3wp.exe (0x1950)                        0x0AD0 Excel Services Application     Excel Calculation Services     8xk9 Medium   ExternalSource.ExecuteOperation: We exhausted all available connection information. Exception: Microsoft.Office.Excel.Server.CalculationServer.Interop.ConnectionInfoException: Exception of type 'Microsoft.Office.Excel.Server.CalculationServer.Interop.ConnectionInfoException' was thrown.     at Microsoft.Office.Excel.Server.CalculationServer.ConnectionInfoManager.GetConnectionInfo(Request request, String externalSourceName, Int32 externalSourceIndex, Boolean& shouldReportFailure)     at Microsoft.Office.Excel.Server.CalculationServer.ExternalSource.ExecuteOperation(Request request, ExternalSourceStateInfo externalSourceStateInfo, ExternalSourceStateInfo prevExternalSourceStateInfo, Int32 index, ConnectionInfoManager connectionInfoManager, ExternalDataScenario scenario, DataOperation dataOpe... fb614a65-e398-4b97-a98d-fb7b23eab39f
    01/21/2012 17:26:47.12* w3wp.exe (0x1950)                        0x0AD0 Excel Services Application     Excel Calculation Services     8xk9 Medium   ...ration, Boolean verifyPreOperationConnection), Data Connection Name: PowerPivot Data, SessionId: 1.V21.4PI+fCwIq52LH++nOoMzs90.5.en-US5.en-US73.-0060#0000-10-00-05T03:00:00:0000#+0000#0000-03-00-05T02:00:00:0000#-006036.bfceb31b-7122-46ca-9e2a-ae52cefcfcaf1.N, UserId: 0#.w|contoso\manager fb614a65-e398-4b97-a98d-fb7b23eab39f

    My server and client olap versions are the same: MSOLAP.5, i used sql server 2008 R2 SP1 and sharepoint 2010 SP1 and reboot or iisreset have no effect

    Thanks in advance for your help

     

    • Spostato Challen FuModerator lunedì 23 gennaio 2012 01:41 (From:SQL Server Analysis Services)
    sabato 21 gennaio 2012 16:53

Risposte

  • Hi Fly,

    Your issue is more relevant to PowerPivot for SharePoint, so I move it to this forum to receive more specific support, thanks for your understanding.

    Just back to your question, SQL Server 2008 R2 PowerPivot workbooks reference MSOLAP.4, while workbooks that you create in the Microsoft SQL Server 2012 add-in will reference MSOLAP.5. So I think you might open the workbook in a earlier version of PowerPivot, if so you cannot refresh newer version workbooks on a SQL Server 2008 R2 instance of PowerPivot for SharePoint. A SQL Server 2008 R2 instance will not process a workbook that you created in the Microsoft SQL Server 2012 Release Candidate 0 (RC 0) version of PowerPivot for Excel.

    If I misunderstand you, please feel free to let me know.

    Thanks,
    Challen Fu

    TechNet Subscriber Support
    If you are
    TechNet Subscription user and have any feedback on our support quality, please send your feedbackhere.


    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    lunedì 23 gennaio 2012 01:54

Tutte le risposte

  • Hi Fly,

    Your issue is more relevant to PowerPivot for SharePoint, so I move it to this forum to receive more specific support, thanks for your understanding.

    Just back to your question, SQL Server 2008 R2 PowerPivot workbooks reference MSOLAP.4, while workbooks that you create in the Microsoft SQL Server 2012 add-in will reference MSOLAP.5. So I think you might open the workbook in a earlier version of PowerPivot, if so you cannot refresh newer version workbooks on a SQL Server 2008 R2 instance of PowerPivot for SharePoint. A SQL Server 2008 R2 instance will not process a workbook that you created in the Microsoft SQL Server 2012 Release Candidate 0 (RC 0) version of PowerPivot for Excel.

    If I misunderstand you, please feel free to let me know.

    Thanks,
    Challen Fu

    TechNet Subscriber Support
    If you are
    TechNet Subscription user and have any feedback on our support quality, please send your feedbackhere.


    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    lunedì 23 gennaio 2012 01:54
  • Thansk you!
    You relsolve my problem. I accidentally installed the wrong version of SQL Server PowerPivot for excel (RC0)
    lunedì 23 gennaio 2012 09:00