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
  • Hello Challen Fu

    I would be so grateful if you could please help me out

    I have been trying to find a solution to the same error message

    In my case, the power pivot reports were working before on a regular team  site , but then two things changed:

    a)  I  created a toplevel site using the BI Center template. Now I am using a Business Intelligence template , created a power pivot gallery library and uploaded a few powerpivot reports

    b)  On the  backend, the database instance was upgrated to SQL Server 2012 

         Front end Server VDSP01  remains  SQL Server 2008 R 2 where Sharepoint 2010  was installed as a FARM  

    Now, the reports will display in sharepoing however they will not refresh. the error message i get is the same.

     Scenario recap:
    a- Server VDSP01  uses SQL Server 2008 R 2 where Sharepoint 2010  was installed as a FARM
    b- On the back end,  the database instance name was replaced with SQL 2012 Server:
    •            from SQL Server 2008 R 2 (instance DBDEV-COTS\COTS)
    •            to     SQL Server 2012 ( instance VTSQL01\COTS)
    c-  I was told that:
        
         From VDSP01, they ran CliConfg.exe   to create SQL Server Alias :
           where    BEFORE: vdsharepoint -->  DBDEV-COTS\COTS
                and  AFTER    : vdsharepoint -->  VTSQL01\COTS

     I appreciate in advance any help you can provide<v:shapetype coordsize="21600,21600" filled="f" id="_x0000_t75" o:preferrelative="t" o:spt="75" path="m@4@5l@4@11@9@11@9@5xe" stroked="f">
      <v:stroke joinstyle="miter">
      <v:formulas>  <v:f eqn="if lineDrawn pixelLineWidth 0">
      <v:f eqn="sum @0 1 0">
      <v:f eqn="sum 0 0 @1">
      <v:f eqn="prod @2 1 2">
      <v:f eqn="prod @3 21600 pixelWidth">
      <v:f eqn="prod @3 21600 pixelHeight">
      <v:f eqn="sum @0 0 1">
      <v:f eqn="prod @6 1 2">
      <v:f eqn="prod @7 21600 pixelWidth">
      <v:f eqn="sum @8 21600 0">
      <v:f eqn="prod @7 21600 pixelHeight">
     <v:f eqn="sum @10 21600 0">
    </v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:formulas>
     <v:path gradientshapeok="t" o:connecttype="rect" o:extrusionok="f">
    <o:lock aspectratio="t" v:ext="edit">
    </o:lock></v:path></v:stroke></v:shapetype> <v:shape alt="" id="Picture_x0020_2" o:spid="_x0000_i1025" style="width:630pt;height:475.5pt;" type="#_x0000_t75">
    <v:imagedata o:href="cid:image002.jpg@01CFBBC9.6DC32580" src="file:///C:\Users\wlarange\AppData\Local\Temp\msohtmlclip1\01\clip_image001.jpg">
    </v:imagedata></v:shape>


    wanda larangeira

    martedì 19 agosto 2014 23:51