Excel Services Issue - Sharepoint 2013 RRS feed

  • Question

  • I'm having issues getting my Excel Services to work in my SharePoint 2013 site.

    I created an odc connection that attaches to a simple cube. 

    I then uploaded the odc connection to my Trusted Data Connections folder on my BI site in SharePoint 2013.

    From there I was able to point to the odc connection in Sharepoint from Excel on my local machine.  I added a pivot table to the spreadsheet and was able to refresh the data and select new columns as expected.

    I then uploaded my spreadsheet to my trusted Documents folder that is contained in the same Sharepoint site as the Data Connections.  I am able to open the document from the Sharepoint location and see the initial view of the data, but when I try to refresh the data or change the selected fields the measures come back empty.  Oddly, I do get back new column information from the request.

    Any advice on what may be causing my issue.

    Monday, July 8, 2013 3:53 PM