Sign in
Microsoft.com
 
SharePoint Products TechCenter
 
 
 
SharePoint Products TechCenter > SharePoint Products and Technologies Forums > SharePoint - Excel Services > Errors Using Report Filter Or Refresh
Ask a questionAsk a question
Search Forums:
 

QuestionErrors Using Report Filter Or Refresh

  • Friday, October 30, 2009 2:22 PMmike_palko Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote

    Greetings, I have cube using SSAS 2008 on ServerA.  I have permissions thru Windows authentication to connect to this cube using an Excel 2007 Pivot table with no problem via ODC that is in a trusted data connection library.  I saved this excel file in a document library on my MOSS 2007 server.  This library is a trusted file location.  I can use the Excel Web Access to see my pivot, but when I try to change the report filter from Calendar year 2009 to 2008 I get the following error:

    "Data Refresh Failed.  Unable to retrieve external data for the following connections.  ServerA MyCube.  The data sources may be unreachable, may not be responding, or may have denied you access.  Verify that data refresh is enabled for the trusted file location and that the workbook data authentication is correctly set."

    Now if I click on the plus next to the 2009 Year, I get the following error:

    "Data Refresh Failed.  Unable to retrieve external data for the following connections:  ServerA MyCube.  The data sources may be unreachable, may not be responding, or may have denied you access.  Verify that data refresh is enabled for the trusted file location and that the workbook data authentication is correctly set."


    Has anyone run across this and how to fix this?  Any information would be helpful.

    Thanks, Mike

     

All Replies

  • Monday, November 16, 2009 7:41 PMKris Lillestol Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote

    Hi Mike,

    A couple questions here to cover some basics:

    1) Is your trusted locatiion set up to allow external data connections?
    2) As your title indicates, the workbook is not refreshing at all, correct?  I just want to make sure this isn't a problem isolated to filtering...

    Regards,

    Kris
     
  • Tuesday, November 17, 2009 3:10 PMmike_palko Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote

    Kris,  thanks for getting back to me on this.  On your two questions, how can I find out if my trusted location is set up to allow external data connections?  Do I find this out on the "Excel Services Edit Trusted File Location" screen in Share Services Administration?  If so, what am I looking for there?

    On your second question, I can use the pivot table that's connected to my cube in the spreadsheet just fine thru Excel 2007 (filtering, add row/column labels, add values, etc.), but the problems I'm having is rendering it thru the Excel Web Access web part.  I can make the spreadsheet appear thru the web part when the web page first comes up (looks like a static snap shot).  However if I want to refresh the connection or change the value in my report filter (the one that is on the spreadsheet), I get error(s).

    Let me know what you think or if need any more information.

    Thanks, Mike

     
  • Friday, November 20, 2009 7:56 PMKris Lillestol Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    I don't have a MOSS 2007 build in front of me at the moment to give you the exact location, but each Trusted File Location should have administrative settings related to External Data.  The setting, in MOSS 2010, is currently titled "Allow External Data" and has three different selections to choose from.